Query to find Employee Name details in Fusion HCM

Query to find Employee Name details in Fusion HCM

 

SELECT papf.person_number,
       papf.person_id,
       papf.start_date,
       ppnf.full_name employee_full_name,
       ppnf.first_name,
       ppnf.last_name,
       ppnf.military_rank,
       ppnf.honors,
       ppnf.suffix,
       ppnf.title -- join with hcm lookups for description
FROM   per_all_people_f papf,
       per_person_names_f ppnf
WHERE  1 = 1
       AND Trunc(sysdate) BETWEEN papf.effective_start_date AND
                                  papf.effective_end_date
       AND papf.person_id = ppnf.person_id
       AND Trunc(sysdate) BETWEEN ppnf.effective_start_date AND
                                  ppnf.effective_end_date
       AND ppnf.name_type = 'GLOBAL'
--and papf.person_number = :p_person_number -- parameter