APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 194: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct

190: AND aid.invoice_line_number = line.line_number
191: AND line.match_type = 'ITEM_TO_PO'
192: AND po.line_location_id = line.po_line_location_id
193: AND EXISTS (
194: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct
195: WHERE jamit.tax_id = jct.tax_id
196: AND apa.invoice_id = jamit.invoice_id
197: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
198: )

Line 246: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct

242: AND aid.posted_flag = 'Y'
243: AND aid.invoice_line_number = line.line_number
244: AND line.rcv_transaction_id = rcv.transaction_id
245: AND EXISTS (
246: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct
247: WHERE jamit.tax_id = jct.tax_id
248: AND apa.invoice_id = jamit.invoice_id
249: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
250: )

Line 390: FROM jai_ap_match_inv_taxes jcdt_st

386:
387:
388: CURSOR c_sum_all_tax_amt_matched(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE, cp_match_type VARCHAR2) IS
389: SELECT NVL(sum(jcdt_st.tax_amount),0)
390: FROM jai_ap_match_inv_taxes jcdt_st
391: , jai_cmn_taxes_all jcta
392: ,ap_invoice_distributions_all aida
393: ,ap_invoice_lines_all line
394: WHERE

Line 409: FROM jai_ap_match_inv_taxes jcdt_st

405: AND aida.accounting_date <= cd_as_of_date;
406:
407: CURSOR c_sum_rv_st_tax_amt_matched(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE, cp_match_type VARCHAR2) IS
408: SELECT sum(jcdt_st.tax_amount)
409: FROM jai_ap_match_inv_taxes jcdt_st
410: , jai_cmn_taxes_all jcta
411: ,ap_invoice_distributions_all aida
412: ,ap_invoice_lines_all line
413: WHERE