APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 222: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

218: WHERE INVOICE_ID = p_inv_id
219: AND LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
220: AND NOT EXISTS
221: (SELECT '1'
222: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
223: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
224: AIDA.INVOICE_DISTRIBUTION_ID
225: AND JCT.TAX_ID = JAMIT.TAX_ID
226: AND UPPER(JCT.TAX_TYPE) IN

Line 412: FROM JAI_AP_MATCH_INV_TAXES JAMIT,

408: -- cursor to Check if Service Tax exists for PO matched Invoice
409: cursor c_po_matched_st_line (cp_inv_dist_id number)
410: IS
411: SELECT '1'
412: FROM JAI_AP_MATCH_INV_TAXES JAMIT,
413: JAI_CMN_TAXES_ALL JCTA
414: WHERE JAMIT.INVOICE_ID = p_inv_id
415: AND JAMIT.INVOICE_DISTRIBUTION_ID = cp_inv_dist_id
416: AND JAMIT.TAX_ID = JCTA.TAX_ID

Line 428: FROM JAI_AP_MATCH_INV_TAXES

424: -- cursor to get parent distribution id for po matched
425: cursor c_get_po_matched_dist_id (cp_inv_dist_id number)
426: is
427: SELECT PARENT_INVOICE_DISTRIBUTION_ID
428: FROM JAI_AP_MATCH_INV_TAXES
429: WHERE INVOICE_ID = p_inv_id
430: AND INVOICE_DISTRIBUTION_ID = cp_inv_dist_id;
431:
432: -- cursor to get parent distribution id for standardalone

Line 527: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

523:
524: CURSOR c_match_inclu_taxes (cp_inv_dist_id number)
525: IS
526: SELECT SUM(JAMIT.tax_amount)
527: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
528: WHERE JAMIT.INVOICE_DISTRIBUTION_ID = cp_inv_dist_id
529: AND JCT.TAX_ID = JAMIT.TAX_ID
530: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
531: AND JCT.TAX_TYPE

Line 2203: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2199: WHERE REGIME_CODE ='SERVICE')
2200: AND REGISTRATION_TYPE = 'TAX_TYPES')
2201: )
2202: AND NOT EXISTS (SELECT 1
2203: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2204: WHERE JAMIT.INVOICE_DISTRIBUTION_ID = aida.INVOICE_DISTRIBUTION_ID
2205: AND JCT.TAX_ID = JAMIT.TAX_ID
2206: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2207: AND JCT.TAX_TYPE

Line 2237: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2233: WHERE INVOICE_ID = cp_inv_id
2234: AND LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
2235: AND NOT EXISTS
2236: (SELECT '1'
2237: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2238: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
2239: AIDA.INVOICE_DISTRIBUTION_ID
2240: AND JCT.TAX_ID = JAMIT.TAX_ID
2241: AND JCT.TAX_TYPE IN

Line 2269: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2265: WHERE REGIME_CODE ='SERVICE')
2266: AND REGISTRATION_TYPE = 'TAX_TYPES')
2267: )
2268: AND NOT EXISTS (SELECT 1
2269: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2270: WHERE JAMIT.INVOICE_DISTRIBUTION_ID = AIDA.INVOICE_DISTRIBUTION_ID
2271: AND JCT.TAX_ID = JAMIT.TAX_ID
2272: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2273: AND JCT.TAX_TYPE

Line 2330: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2326: WHERE REGIME_CODE ='SERVICE')
2327: AND REGISTRATION_TYPE = 'TAX_TYPES')
2328: )
2329: AND NOT EXISTS (SELECT 1
2330: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2331: WHERE JAMIT.INVOICE_DISTRIBUTION_ID = aida.INVOICE_DISTRIBUTION_ID
2332: AND JCT.TAX_ID = JAMIT.TAX_ID
2333: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2334: AND JCT.TAX_TYPE

Line 2366: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2362: AND AIDA.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID(+) --Added by Chong for bug#16367707
2363: AND AIDA.LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
2364: AND NOT EXISTS
2365: (SELECT '1'
2366: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2367: WHERE JAMIT.INVOICE_DISTRIBUTION_ID =
2368: AIDA.INVOICE_DISTRIBUTION_ID
2369: AND JCT.TAX_ID = JAMIT.TAX_ID
2370: AND JCT.TAX_TYPE IN

Line 2398: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2394: WHERE REGIME_CODE ='SERVICE')
2395: AND REGISTRATION_TYPE = 'TAX_TYPES')
2396: )
2397: AND NOT EXISTS (SELECT 1
2398: FROM JAI_AP_MATCH_INV_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2399: WHERE JAMIT.INVOICE_DISTRIBUTION_ID = AIDA.INVOICE_DISTRIBUTION_ID
2400: AND JCT.TAX_ID = JAMIT.TAX_ID
2401: AND JCT.INCLUSIVE_TAX_FLAG = 'Y'
2402: AND JCT.TAX_TYPE