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