HR Per All People F Diagnostic Listing

➜ Back to Library
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 NameSQL textValidation
Effective Date
trunc(:p_eff_date) between papf.effective_start_date and papf.effective_end_date
Date
Download
Related Blitz Reports
PO Item Summary Listing XXDPF Shortages ECC Discrete Manufacturing, Resources PO Item Detail Listing TB GL Account Analysis (Drilldown)v2 PO RFQ Action Required ECC Procurement, Purchase Orders FA Asset Book Details PO Closeout Checklist Template
Blitz Report™