eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_AR_APPLICABLE_TAXES dependencies on PER_ALL_PEOPLE_F

Line 282: -- SELECT DISTINCT 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF

278: -- AP tax payer id available check
279: -- Bug 14563117 Start
280: DECLARE
281: Cursor C_TaxPayer Is
282: -- SELECT DISTINCT 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
283: SELECT /*+ cardinality(PV.PAV,1) */ 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
284: -- Bug 14563117 End
285: WHERE NVL(pv.employee_id, - 99) = papf.person_id (+)
286: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE

Line 283: SELECT /+ cardinality(PV.PAV,1) / 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF

279: -- Bug 14563117 Start
280: DECLARE
281: Cursor C_TaxPayer Is
282: -- SELECT DISTINCT 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
283: SELECT /*+ cardinality(PV.PAV,1) */ 'Y' taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
284: -- Bug 14563117 End
285: WHERE NVL(pv.employee_id, - 99) = papf.person_id (+)
286: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
287: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 526: PER_ALL_PEOPLE_F PAPF

522: APIND.INVOICE_DISTRIBUTION_ID
523: FROM PO_VENDORS PV,
524: AP_INVOICES APINA,
525: AP_INVOICE_DISTRIBUTIONS APIND,
526: PER_ALL_PEOPLE_F PAPF
527: WHERE PV.VENDOR_ID = APINA.VENDOR_ID
528: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
529: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
530: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 925: PER_ALL_PEOPLE_F PAPF

921: SELECT SAWT.SUPP_AWT_TYPE_ID
922: INTO l_SUPP_AWT_TYPE_ID_CD
923: FROM PO_VENDORS PV,
924: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
925: PER_ALL_PEOPLE_F PAPF
926: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
927: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
928: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
929: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 1058: PO_VENDORS PV, JL_ZZ_AP_SUPP_AWT_TYPES SAWT, PER_ALL_PEOPLE_F PAPF

1054: -- TO GET THE CURRENT MONTH SUPP_AWT_CODE_ID FOR THE PRESENT TAX_ID
1055:
1056: SELECT SAWTC.SUPP_AWT_CODE_ID INTO l_SUPP_AWT_CODE_ID_CD
1057: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
1058: PO_VENDORS PV, JL_ZZ_AP_SUPP_AWT_TYPES SAWT, PER_ALL_PEOPLE_F PAPF
1059: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
1060: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1061: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
1062: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 1370: SELECT PV.VENDOR_ID INTO l_VENDOR_ID FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF

1366: BEGIN
1367:
1368: SELECT JL_ZZ_AP_SUPP_AWT_TYPES_s.nextval INTO l_SUPP_AWT_TYPE_ID_TYPES FROM dual;
1369:
1370: SELECT PV.VENDOR_ID INTO l_VENDOR_ID FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
1371: WHERE NVL(pv.employee_id, - 99) = papf.person_id (+)
1372: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
1373: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE
1374: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

Line 1433: PER_ALL_PEOPLE_F PAPF

1429: SELECT SAWT.SUPP_AWT_TYPE_ID
1430: INTO l_SUPP_AWT_TYPE_ID_CD
1431: FROM PO_VENDORS PV,
1432: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
1433: PER_ALL_PEOPLE_F PAPF
1434: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
1435: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1436: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
1437: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 1584: PER_ALL_PEOPLE_F PAPF

1580: INTO l_SUPP_AWT_CODE_ID_CD
1581: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
1582: PO_VENDORS PV,
1583: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
1584: PER_ALL_PEOPLE_F PAPF
1585: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
1586: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1587: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
1588: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 1891: PER_ALL_PEOPLE_F PAPF

1887: APIND.INVOICE_DISTRIBUTION_ID
1888: FROM PO_VENDORS PV,
1889: AP_INVOICES APINA,
1890: AP_INVOICE_DISTRIBUTIONS APIND,
1891: PER_ALL_PEOPLE_F PAPF
1892: WHERE PV.VENDOR_ID = APINA.VENDOR_ID
1893: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
1894: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
1895: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 2000: SELECT DISTINCT 'Y' INTO l_taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF

1996: END IF;
1997: -- AP tax payer id available check
1998:
1999: BEGIN
2000: SELECT DISTINCT 'Y' INTO l_taxpayer FROM PO_VENDORS PV, PER_ALL_PEOPLE_F PAPF
2001: WHERE NVL(pv.employee_id, - 99) = papf.person_id (+)
2002: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
2003: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE
2004: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

Line 2114: PER_ALL_PEOPLE_F PAPF

2110: l_SUPP_AWT_CODE_ID_CD
2111: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
2112: PO_VENDORS PV,
2113: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
2114: PER_ALL_PEOPLE_F PAPF
2115: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
2116: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
2117: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
2118: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE

Line 2238: PER_ALL_PEOPLE_F PAPF

2234: INTO l_SUPP_AWT_CODE_ID_CD
2235: FROM JL_ZZ_AP_SUP_AWT_CD SAWTC,
2236: PO_VENDORS PV,
2237: JL_ZZ_AP_SUPP_AWT_TYPES SAWT,
2238: PER_ALL_PEOPLE_F PAPF
2239: WHERE SAWT.VENDOR_ID = PV.VENDOR_ID
2240: AND NVL(pv.employee_id, - 99) = papf.person_id (+)
2241: AND NVL(papf.EFFECTIVE_START_DATE, SYSDATE) <= SYSDATE
2242: AND NVL(papf.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE