ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F03850410366919AE05362FB0905B416Y 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 US HR Per All People F Diagnostic Listing Diagnostic Listing of per_all_people_f table 1=1 1 10 1=1 trunc(:p_eff_date) between papf.effective_start_date and papf.effective_end_date Date trunc(sysdate) US Effective Date