DBA Data[Home] [Help]

APPS.JE_IT_XML_LISTING_PKG dependencies on PER_ALL_PEOPLE_F

Line 777: FROM per_all_people_f

773: SELECT 1
774: FROM ap_suppliers pv,
775: (SELECT distinct person_id
776: ,national_identifier
777: FROM per_all_people_f
778: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf
779: WHERE pv.employee_id = papf.person_id (+)
780: AND NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)) = c_taxpayer_id;
781: