Query to find employee number in fusion hcm

SELECT papf.person_number,
       papf.person_id,
       start_date,
       effective_start_date,
       effective_end_date
FROM   per_all_people_f papf
--           per_person_secured_list_v papf --- secured list table
WHERE  1 = 1
       AND TRUNC(sysdate) BETWEEN effective_start_date AND effective_end_date
--and papf.person_number = :p_person_number -- parameter

No comments:

Post a Comment