APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 139: jai_cmn_document_taxes jdt

135: ,apa.invoice_type_lookup_code) ='APPROVED' )
136: AND invoice_type_lookup_code NOT IN ('DEBIT', 'CREDIT')
137: AND EXISTS (
138: SELECT 1 FROM
139: jai_cmn_document_taxes jdt
140: WHERE apa.invoice_id = jdt.source_doc_id
141: AND jdt.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
142: )
143: AND jail.organization_id = nvl(cp_organization_id,jail.organization_id)

Line 350: FROM jai_cmn_document_taxes jcdt

346: AND aila.line_type_lookup_code = 'PREPAY';
347:
348: CURSOR c_sum_all_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
349: SELECT NVL(SUM(jcdt.tax_amt),0)
350: FROM jai_cmn_document_taxes jcdt
351: ,jai_cmn_taxes_all jcta
352: ,jai_ap_invoice_lines jail
353: ,ap_invoice_distributions_all aida
354: WHERE

Line 370: FROM jai_cmn_document_taxes jcdt

366: --Added by Qiong for reverse charge bug#16001407 begin
367:
368: CURSOR c_sum_rv_st_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
369: SELECT sum(jcdt.tax_amt)
370: FROM jai_cmn_document_taxes jcdt
371: ,jai_ap_invoice_lines jail
372: ,ap_invoice_distributions_all aida
373: WHERE
374: jcdt.source_doc_id = cp_invoice_id