APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on PER_ALL_PEOPLE_F

Line 1087: (select distinct person_id ,national_identifier from per_all_people_f

1083: aps.global_attribute12,
1084: aps.segment1,
1085: aps.vendor_id
1086: FROM ap_suppliers aps,
1087: (select distinct person_id ,national_identifier from per_all_people_f
1088: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1089: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
1090: WHERE ap_trx.party_id = povapf.vendor_id
1091: AND jlcgn.nit(+) = REPLACE(povapf.num_1099,'-') ;

Line 1115: (select distinct person_id ,national_identifier from per_all_people_f

1111: aps.global_attribute12,
1112: aps.segment1,
1113: aps.vendor_id
1114: FROM ap_suppliers aps,
1115: (select distinct person_id ,national_identifier from per_all_people_f
1116: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1117: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
1118: WHERE l_supplier_num = povapf.segment1
1119: AND jlcgn.nit(+) = REPLACE(povapf.num_1099,'-') ;

Line 1315: FROM ap_suppliers aps,(select distinct person_id ,national_identifier from per_all_people_f

1311: PO_DISTRIBUTIONS_ALL podis,
1312: (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
1313: aps.vendor_name,aps.global_attribute10,aps.global_attribute12,aps.segment1,
1314: aps.vendor_id
1315: FROM ap_suppliers aps,(select distinct person_id ,national_identifier from per_all_people_f
1316: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1317: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf,
1318: xla_ae_lines AEL,
1319: gl_import_references R,

Line 1354: from per_all_people_f

1350: xla_ae_lines AEL, gl_import_references gir,
1351: xla_distribution_links LNK,(SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099, aps.vendor_name,
1352: aps.global_attribute10, aps.global_attribute12, aps.segment1, aps.vendor_id
1353: FROM ap_suppliers aps,(select distinct person_id , national_identifier
1354: from per_all_people_f
1355: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1356: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf
1357: WHERE povapf.vendor_id = poha.vendor_id
1358: AND REPLACE(povapf.num_1099,'-') = jlcgn.nit(+)

Line 1576: (select distinct person_id ,national_identifier from per_all_people_f

1572: pov.global_attribute12,
1573: pov.segment1,
1574: pov.vendor_id
1575: FROM po_vendors pov,
1576: (select distinct person_id ,national_identifier from per_all_people_f
1577: WHERE nvl(EFFECTIVE_END_DATE,sysdate) >= sysdate) papf --bug 8664192
1578: WHERE nvl(pov.employee_id, -99) = papf.person_id (+))povpapf
1579: WHERE poha.po_header_id = TO_NUMBER(p_journal_rec.ref_2)
1580: AND povpapf.vendor_id = poha.vendor_id