APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 396: FROM JAI_CMN_DOCUMENT_TAXES JCDT, JAI_CMN_TAXES_ALL JCTA

392: -- cursor to Check if Service Tax exists for Standalone Invoice
393: cursor c_standalone_st_line (cp_invoice_line_number number)
394: IS
395: SELECT '1'
396: FROM JAI_CMN_DOCUMENT_TAXES JCDT, JAI_CMN_TAXES_ALL JCTA
397: WHERE JCDT.SOURCE_DOC_ID = p_inv_id
398: AND JCDT.SOURCE_DOC_LINE_ID = cp_invoice_line_number
399: AND JCDT.SOURCE_DOC_TYPE = 'STANDALONE_INVOICE'
400: AND JCDT.TAX_ID = JCTA.TAX_ID

Line 437: JAI_CMN_DOCUMENT_TAXES jcdt

433: cursor c_get_standalone_dist_id
434: is
435: SELECT aida.INVOICE_DISTRIBUTION_ID
436: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,
437: JAI_CMN_DOCUMENT_TAXES jcdt
438: WHERE jcdt.SOURCE_DOC_ID = p_inv_id
439: AND aida.INVOICE_LINE_NUMBER = jcdt.SOURCE_DOC_PARENT_LINE_NO
440: ORDER BY aida.INVOICE_DISTRIBUTION_ID;
441:

Line 510: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

506: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
507: CURSOR c_std_inclu_taxes (cp_inv_line_num number)
508: IS
509: SELECT sum(JAMIT.tax_amt)
510: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
511: WHERE
512: JAMIT.source_doc_id = p_inv_id
513: AND JAMIT.source_doc_parent_line_no = cp_inv_line_num
514: AND JCT.TAX_ID = JAMIT.TAX_ID

Line 2188: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2184: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2185: AND AMOUNT > 0
2186: AND NVL(REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2187: AND NOT EXISTS (SELECT 1
2188: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2189: WHERE
2190: JAMIT.source_doc_id = aida.invoice_id
2191: AND JAMIT.source_doc_line_id = aida.invoice_line_number
2192: AND JCT.TAX_ID = JAMIT.TAX_ID

Line 2254: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2250: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2251: AND AMOUNT > 0
2252: AND NVL(REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2253: AND NOT EXISTS (SELECT 1
2254: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2255: WHERE
2256: JAMIT.source_doc_id = AIDA.invoice_id
2257: AND JAMIT.source_doc_line_id = AIDA.invoice_line_number
2258: AND JCT.TAX_ID = JAMIT.TAX_ID

Line 2315: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2311: ('PREPAY', 'TIPV', 'TERV', 'TAX', 'MISCELLANEOUS') -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2312: AND AIDA.AMOUNT > 0
2313: AND NVL(AIDA.REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2314: AND NOT EXISTS (SELECT 1
2315: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2316: WHERE
2317: JAMIT.source_doc_id = aida.invoice_id
2318: AND JAMIT.source_doc_line_id = aida.invoice_line_number
2319: AND JCT.TAX_ID = JAMIT.TAX_ID

Line 2383: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT

2379: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
2380: AND AIDA.AMOUNT > 0
2381: AND NVL(AIDA.REVERSAL_FLAG,'N') <> 'Y' --Added NVL by Chong for bug#16274617 new added dist line, this flag is null
2382: AND NOT EXISTS (SELECT 1
2383: FROM JAI_CMN_DOCUMENT_TAXES JAMIT, JAI_CMN_TAXES_ALL JCT
2384: WHERE
2385: JAMIT.source_doc_id = AIDA.invoice_id
2386: AND JAMIT.source_doc_line_id = AIDA.invoice_line_number
2387: AND JCT.TAX_ID = JAMIT.TAX_ID

Line 2445: JAI_CMN_DOCUMENT_TAXES jcdt

2441: begin
2442: begin
2443: SELECT aida.INVOICE_DISTRIBUTION_ID INTO cp_inv_dist_id
2444: FROM AP_INVOICE_DISTRIBUTIONS_ALL aida,
2445: JAI_CMN_DOCUMENT_TAXES jcdt
2446: WHERE jcdt.SOURCE_DOC_ID = cp_inv_id
2447: AND jcdt.SOURCE_DOC_LINE_ID = cp_inv_line_number -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
2448: AND jcdt.SOURCE_DOC_ID = aida.INVOICE_ID
2449: AND aida.INVOICE_LINE_NUMBER = jcdt.SOURCE_DOC_PARENT_LINE_NO