APPS.JAI_PA_COSTING_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 556: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b

552: select
553: nvl(sum(a.base_amount),0) functional_tax_amount,
554: nvl(sum(a.tax_amount),0) transaction_tax_amount
555: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
556: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b
557: where a.tax_id = b.tax_id
558: and nvl(b.mod_cr_percentage, 0) = 0
559: and (a.invoice_id, a.parent_invoice_distribution_id) =
560: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all

Line 574: jai_ap_match_inv_taxes a

570: INTO
571: ln_func_inclu_reco_tax_amt
572: , ln_trx_inclu_reco_tax_amt
573: FROM
574: jai_ap_match_inv_taxes a
575: , jai_cmn_taxes_all b
576: WHERE a.tax_id = b.tax_id
577: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
578: AND a.recoverable_flag = 'Y'