APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on PER_ALL_PEOPLE_F

Line 804: (select distinct person_id ,national_identifier from per_all_people_f

800: aps.global_attribute12,
801: aps.segment1,
802: aps.vendor_id
803: FROM ap_suppliers aps,
804: (select distinct person_id ,national_identifier from per_all_people_f
805: where nvl(EFFECTIVE_END_DATE,sysdate)>=sysdate) papf
806: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
807: WHERE ap_trx.party_id = povapf.vendor_id
808: AND jlcgn.nit(+) = REPLACE(povapf.num_1099,'-') ;

Line 832: (select distinct person_id ,national_identifier from per_all_people_f

828: aps.global_attribute12,
829: aps.segment1,
830: aps.vendor_id
831: FROM ap_suppliers aps,
832: (select distinct person_id ,national_identifier from per_all_people_f
833: where nvl(EFFECTIVE_END_DATE,sysdate)>=sysdate) papf
834: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
835: WHERE l_supplier_num = povapf.segment1
836: AND jlcgn.nit(+) = REPLACE(povapf.num_1099,'-') ;

Line 1031: (select distinct person_id ,national_identifier from per_all_people_f

1027: aps.global_attribute12,
1028: aps.segment1,
1029: aps.vendor_id
1030: FROM ap_suppliers aps,
1031: (select distinct person_id ,national_identifier from per_all_people_f
1032: where nvl(EFFECTIVE_END_DATE,sysdate)>=sysdate) papf
1033: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
1034: WHERE poha.po_header_id = TO_NUMBER(p_journal_rec.ref_2)
1035: AND povapf.vendor_id = poha.vendor_id