Oracle EBS Employee Table and HRMS Tables: Date-Tracked SQL Generator

SELECT p.person_id,
       p.employee_number,
       p.full_name,
       p.email_address,
       a.assignment_id,
       a.assignment_number,
       o.name        AS organization,
       j.name        AS job,
       s.full_name   AS supervisor,
       p.effective_start_date AS person_from,
       a.effective_start_date AS assignment_from
FROM   per_all_people_f      p
       JOIN per_all_assignments_f a
         ON a.person_id = p.person_id
        AND a.assignment_type = 'E'
        AND a.primary_flag = 'Y'
        AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
       LEFT JOIN hr_all_organization_units o
         ON o.organization_id = a.organization_id
       LEFT JOIN per_jobs_vl j
         ON j.job_id = a.job_id
       LEFT JOIN per_all_people_f s
         ON s.person_id = a.supervisor_id
        AND TRUNC(SYSDATE) BETWEEN s.effective_start_date AND s.effective_end_date
WHERE  p.business_group_id = 202
 AND   p.current_employee_flag = 'Y'
 AND   p.last_name LIKE UPPER('%')
 AND   TRUNC(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
ORDER BY p.full_name
FETCH FIRST 200 ROWS ONLY;

SELECT person_id, employee_number, last_name, first_name,
       effective_start_date, effective_end_date
FROM   per_all_people_f
WHERE  person_id = :person_id
ORDER BY effective_start_date;

SELECT u.user_name, u.employee_id AS person_id, p.full_name
FROM   fnd_user u
       JOIN per_all_people_f p
         ON p.person_id = u.employee_id
        AND TRUNC(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
WHERE  u.end_date IS NULL OR u.end_date > TRUNC(SYSDATE);