HR Per All People F Diagnostic Listing

Description
Diagnostic Listing of per_all_people_f table
select
papf.full_name,
papf.person_id,
papf.effective_start_date,
papf.effective_end_date,
nvl2(pa.agent_id,'Y','N') is_buyer_yn
from
hr.per_all_people_f papf,
po_agents pa
where
1=1 and
papf.person_id = pa.agent_id (+)
order by
nvl2(pa.agent_id,'Y','N') desc,
papf.full_name,
papf.effective_start_date
Parameter Name SQL text Validation
Effective Date
trunc(:p_eff_date) between papf.effective_start_date and papf.effective_end_date
Date