APPS.JE_ES_WHTAX dependencies on PER_ALL_PEOPLE_F

Line 691: FROM PER_ALL_PEOPLE_F) papf

687: ap_tax_codes_all atc,
688: ap_awt_tax_rates_all awt,
689: (SELECT distinct person_id
690: ,national_identifier
691: FROM PER_ALL_PEOPLE_F) papf
692: WHERE v.vendor_id = vs.vendor_id
693: AND nvl(v.employee_id,-99) = papf.person_id (+)
694: AND vs.tax_reporting_site_flag = 'Y'
695: AND vs.country = fl.lookup_code(+)

Line 773: FROM PER_ALL_PEOPLE_F) papf

769: ap_invoice_lines_all line,
770: ap_invoice_distributions_all dist,
771: (SELECT distinct person_id
772: ,national_identifier
773: FROM PER_ALL_PEOPLE_F) papf
774: WHERE v.vendor_id = vs.vendor_id
775: AND nvl(v.employee_id,-99) = papf.person_id (+)
776: AND vs.tax_reporting_site_flag = 'Y'
777: AND vs.country = fl.lookup_code(+)

Line 902: FROM PER_ALL_PEOPLE_F) papf

898: ap_invoice_lines_all line,
899: ap_invoice_distributions_all dist,
900: (SELECT distinct person_id
901: ,national_identifier
902: FROM PER_ALL_PEOPLE_F) papf
903: WHERE vs.country = fl.lookup_code(+)
904: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
905: ---AND v.vendor_id = nvl(p_vendor_id,v.vendor_id)
906: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))

Line 1050: FROM PER_ALL_PEOPLE_F) papf

1046: ap_invoice_lines_all line,
1047: ap_invoice_distributions_all dist,
1048: (SELECT distinct person_id
1049: ,national_identifier
1050: FROM PER_ALL_PEOPLE_F) papf
1051: WHERE vs.country = fl.lookup_code(+)
1052: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1053: ---AND v.vendor_id = nvl(p_vendor_id,v.vendor_id)
1054: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))

Line 1212: FROM PER_ALL_PEOPLE_F) papf

1208: ap_invoice_lines_all line,
1209: ap_invoice_distributions_all dist,
1210: (SELECT distinct person_id
1211: ,national_identifier
1212: FROM PER_ALL_PEOPLE_F) papf
1213: WHERE vs.country = fl.lookup_code(+)
1214: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1215: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1216: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1326: FROM PER_ALL_PEOPLE_F) papf

1322: ap_invoice_lines_all line,
1323: ap_invoice_distributions_all dist,
1324: (SELECT distinct person_id
1325: ,national_identifier
1326: FROM PER_ALL_PEOPLE_F) papf
1327: WHERE vs.country = fl.lookup_code(+)
1328: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1329: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1330: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1457: FROM PER_ALL_PEOPLE_F) papf

1453: ap_invoice_lines_all line,
1454: ap_invoice_distributions_all dist,
1455: (SELECT distinct person_id
1456: ,national_identifier
1457: FROM PER_ALL_PEOPLE_F) papf
1458: WHERE vs.country = fl.lookup_code(+)
1459: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1460: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1461: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1601: FROM PER_ALL_PEOPLE_F) papf

1597: ap_invoice_lines_all line,
1598: ap_invoice_distributions_all dist,
1599: (SELECT distinct person_id
1600: ,national_identifier
1601: FROM PER_ALL_PEOPLE_F) papf
1602: WHERE vs.country = fl.lookup_code(+)
1603: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1604: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1605: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1751: FROM PER_ALL_PEOPLE_F) papf

1747: ap_invoice_lines_all line,
1748: ap_invoice_distributions_all dist,
1749: (SELECT distinct person_id
1750: ,national_identifier
1751: FROM PER_ALL_PEOPLE_F) papf
1752: WHERE vs.country = fl.lookup_code(+)
1753: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1754: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1755: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1856: FROM PER_ALL_PEOPLE_F) papf

1852: ap_invoice_lines_all line,
1853: ap_invoice_distributions_all dist,
1854: (SELECT distinct person_id
1855: ,national_identifier
1856: FROM PER_ALL_PEOPLE_F) papf
1857: WHERE vs.country = fl.lookup_code(+)
1858: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1859: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1860: AND nvl(v.employee_id,-99) = papf.person_id (+)