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 DUAL

Line 288: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

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
288: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
289: AND rtrim(
290: substr(
291: replace(
292: nvl(papf.national_identifier,

Line 293: nvl(pv.individual_1099,pv.num_1099)

289: AND rtrim(
290: substr(
291: replace(
292: nvl(papf.national_identifier,
293: nvl(pv.individual_1099,pv.num_1099)
294: ),
295: '-'),
296: 1,10)
297: ) ||

Line 539: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYERID_C);

535: -- (SELECT LOCATION_ID FROM HR_LOCATIONS_ALL WHERE UPPER(LOCATION_CODE) = 'BUENOS AIRES' --bug 8622329
536: (SELECT LOCATION_ID FROM HR_LOCATIONS_ALL WHERE UPPER(REGION_2) = 'BUENOS AIRES' --bug 9865805
537: AND trunc(SYSDATE) <= NVL(inactive_DATE, trunc(SYSDATE)))
538: AND NVL(APINA.INVOICE_AMOUNT,0) <> NVL(APINA.AMOUNT_PAID,0)
539: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYERID_C);
540: AND rtrim(
541: substr(
542: replace(
543: nvl(papf.national_identifier,

Line 544: nvl(pv.individual_1099,pv.num_1099)

540: AND rtrim(
541: substr(
542: replace(
543: nvl(papf.national_identifier,
544: nvl(pv.individual_1099,pv.num_1099)
545: ),
546: '-'),
547: 1,10)
548: ) ||

Line 931: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_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
930: AND SAWT.AWT_TYPE_CODE = l_AWT_TAX_TYPE
931: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
932: AND rtrim(
933: substr(
934: replace(
935: nvl(papf.national_identifier,

Line 936: nvl(pv.individual_1099,pv.num_1099)

932: AND rtrim(
933: substr(
934: replace(
935: nvl(papf.national_identifier,
936: nvl(pv.individual_1099,pv.num_1099)
937: ),
938: '-'),
939: 1,10)
940: ) ||

Line 949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

945: FND_FILE.put_line( FND_FILE.LOG,'17. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
946: END IF;
947:
948:
949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
950:
951: IF p_debug_log = 'Y' THEN
952: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
953: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

Line 1070: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

1066: AND SAWTC.TAX_ID = l_tax_id
1067: AND SAWTC.EFFECTIVE_START_DATE = l_START_DATE
1068: AND SAWTC.primary_tax_flag = 'Y'
1069: AND sawtc.effective_end_DATE IS NULL
1070: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
1071: AND rtrim(
1072: substr(
1073: replace(
1074: nvl(papf.national_identifier,

Line 1075: nvl(pv.individual_1099,pv.num_1099)

1071: AND rtrim(
1072: substr(
1073: replace(
1074: nvl(papf.national_identifier,
1075: nvl(pv.individual_1099,pv.num_1099)
1076: ),
1077: '-'),
1078: 1,10)
1079: ) ||

Line 1082: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

1078: 1,10)
1079: ) ||
1080: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
1081:
1082: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF p_debug_log = 'Y' THEN

Line 1164: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

1160: INV_REC.INVOICE_DISTRIBUTION_ID); --Invoice distribution ID -- R12 Changes
1161:
1162:
1163:
1164: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1165:
1166: IF p_debug_log = 'Y' THEN
1167: FND_FILE.put_line( FND_FILE.LOG,'22. C '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1168: END IF;

Line 1368: SELECT JL_ZZ_AP_SUPP_AWT_TYPES_s.nextval INTO l_SUPP_AWT_TYPE_ID_TYPES FROM dual;

1364: ELSE --- If wht unique then INSERT INTO JL_ZZ_AP_SUPP_AWT_TYPES (3.3.2)
1365:
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

Line 1374: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

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);
1375: AND rtrim(
1376: substr(
1377: replace(
1378: nvl(papf.national_identifier,

Line 1379: nvl(pv.individual_1099,pv.num_1099)

1375: AND rtrim(
1376: substr(
1377: replace(
1378: nvl(papf.national_identifier,
1379: nvl(pv.individual_1099,pv.num_1099)
1380: ),
1381: '-'),
1382: 1,10)
1383: ) ||

Line 1439: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_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
1438: AND SAWT.AWT_TYPE_CODE = l_AWT_TAX_TYPE
1439: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
1440: AND rtrim(
1441: substr(
1442: replace(
1443: nvl(papf.national_identifier,

Line 1444: nvl(pv.individual_1099,pv.num_1099)

1440: AND rtrim(
1441: substr(
1442: replace(
1443: nvl(papf.national_identifier,
1444: nvl(pv.individual_1099,pv.num_1099)
1445: ),
1446: '-'),
1447: 1,10)
1448: ) ||

Line 1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

1453: FND_FILE.put_line( FND_FILE.LOG,'36. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
1454: END IF;
1455:
1456:
1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
1458:
1459: IF p_debug_log = 'Y' THEN
1460: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

Line 1596: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

1592: AND SAWTC.TAX_ID = l_tax_id
1593: AND SAWTC.primary_tax_flag = 'Y'
1594: AND SAWTC.EFFECTIVE_START_DATE = l_START_DATE
1595: AND sawtc.effective_end_DATE IS NULL
1596: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
1597: AND rtrim(
1598: substr(
1599: replace(
1600: nvl(papf.national_identifier,

Line 1601: nvl(pv.individual_1099,pv.num_1099)

1597: AND rtrim(
1598: substr(
1599: replace(
1600: nvl(papf.national_identifier,
1601: nvl(pv.individual_1099,pv.num_1099)
1602: ),
1603: '-'),
1604: 1,10)
1605: ) ||

Line 1608: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

1604: 1,10)
1605: ) ||
1606: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
1607:
1608: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: IF p_debug_log = 'Y' THEN

Line 1687: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

1683:
1684:
1685:
1686:
1687: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1688:
1689: IF p_debug_log = 'Y' THEN
1690: FND_FILE.put_line( FND_FILE.LOG,'45 A. '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1691: END IF;

Line 1904: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYERID_C);

1900: -- (SELECT LOCATION_ID FROM HR_LOCATIONS_ALL WHERE UPPER(LOCATION_CODE) = 'BUENOS AIRES' AND trunc(SYSDATE) <= NVL(inactive_DATE, trunc(SYSDATE))) --bug 8622329
1901: (SELECT LOCATION_ID FROM HR_LOCATIONS_ALL WHERE UPPER(REGION_2) = 'BUENOS AIRES' AND trunc(SYSDATE) <= NVL(inactive_DATE, trunc(SYSDATE))) --bug 9865805
1902: AND APINA.INVOICE_ID = APIND.INVOICE_ID
1903: AND NVL(APINA.INVOICE_AMOUNT,0) <> NVL(APINA.AMOUNT_PAID,0)
1904: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYERID_C);
1905: AND rtrim(
1906: substr(
1907: replace(
1908: nvl(papf.national_identifier,

Line 1909: nvl(pv.individual_1099,pv.num_1099)

1905: AND rtrim(
1906: substr(
1907: replace(
1908: nvl(papf.national_identifier,
1909: nvl(pv.individual_1099,pv.num_1099)
1910: ),
1911: '-'),
1912: 1,10)
1913: ) ||

Line 2004: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

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);
2005: AND rtrim(
2006: substr(
2007: replace(
2008: nvl(papf.national_identifier,

Line 2009: nvl(pv.individual_1099,pv.num_1099)

2005: AND rtrim(
2006: substr(
2007: replace(
2008: nvl(papf.national_identifier,
2009: nvl(pv.individual_1099,pv.num_1099)
2010: ),
2011: '-'),
2012: 1,10)
2013: ) ||

Line 2079: SELECT last_day(l_START_DATE_SEC_MAX) INTO l_END_DATE_SEC_MAX FROM dual;

2075:
2076:
2077: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID;
2078:
2079: SELECT last_day(l_START_DATE_SEC_MAX) INTO l_END_DATE_SEC_MAX FROM dual;
2080:
2081: EXCEPTION
2082: WHEN NO_DATA_FOUND THEN
2083: IF p_debug_log = 'Y' THEN

Line 2125: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

2121: AND SAWTC.primary_tax_flag = 'Y'
2122: --AND SAWT.WH_SUBJECT_FLAG = 'Y' -- Indicates whether the supplier is subject to the withholding tax type
2123: AND SAWTC.TAX_ID IN (SELECT TAX_ID FROM AP_TAX_CODES WHERE name LIKE 'TURN_BSAS_GRP%')
2124: AND SAWTC.EFFECTIVE_END_DATE IS NULL
2125: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
2126: AND rtrim(
2127: substr(
2128: replace(
2129: nvl(papf.national_identifier,

Line 2130: nvl(pv.individual_1099,pv.num_1099)

2126: AND rtrim(
2127: substr(
2128: replace(
2129: nvl(papf.national_identifier,
2130: nvl(pv.individual_1099,pv.num_1099)
2131: ),
2132: '-'),
2133: 1,10)
2134: ) ||

Line 2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:
2149:
2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
2151:
2152:
2153: INSERT INTO JL_ZZ_AP_SUP_AWT_CD
2154: (SUPP_AWT_CODE_ID,

Line 2249: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);

2245: AND SAWTC.TAX_ID = l_TAX_ID_DEF_ATC -- to pick up the tax code WHERE tax id is def ATC
2246: AND SAWTC.primary_tax_flag = 'Y'
2247: --AND SAWT.WH_SUBJECT_FLAG = 'Y'
2248: AND sawtc.effective_end_DATE IS NULL
2249: --bug 8530918 AND NVL(papf.national_identifier, NVL(pv.individual_1099, pv.num_1099)) = TO_CHAR(l_TAXPAYER_ID);
2250: AND rtrim(
2251: substr(
2252: replace(
2253: nvl(papf.national_identifier,

Line 2254: nvl(pv.individual_1099,pv.num_1099)

2250: AND rtrim(
2251: substr(
2252: replace(
2253: nvl(papf.national_identifier,
2254: nvl(pv.individual_1099,pv.num_1099)
2255: ),
2256: '-'),
2257: 1,10)
2258: ) ||

Line 2261: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

2257: 1,10)
2258: ) ||
2259: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
2260:
2261: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
2262:
2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: IF p_debug_log = 'Y' THEN

Line 2339: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;

2335: l_ORG_ID, --ORG_ID
2336: INV_REC.INVOICE_DISTRIBUTION_ID); --Invoice distribution ID -- R12 Changes
2337:
2338:
2339: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
2340:
2341: IF p_debug_log = 'Y' THEN
2342: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 A. INSERTED RECORDS INTO JL_ZZ_AP_INV_DIS_WH_S '|| SQL%ROWCOUNT || 'RECORDS' || SQLCODE ||' -ERROR- '|| SQLERRM);
2343: END IF;