DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on JAI_PO_TAXES

Line 282: from JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

278: a.tax_amount * decode( nvl(a.modvat_flag, 'N'), 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100))
279: )
280: ),0) transaction_tax_amount
281: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
282: from JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
283: where a.tax_id = b.tax_id
284: and (
285: ( pn_transaction_dist_id is not null and a.line_location_id = r_get_po_dist_dtl.line_location_id )
286: or ( pn_transaction_dist_id is null and a.po_header_id = pn_transaction_header_id)

Line 306: jai_po_taxes a

302: INTO
303: ln_func_inclu_reco_tax_amt
304: , ln_trx_inclu_reco_tax_amt
305: FROM
306: jai_po_taxes a
307: , jai_cmn_taxes_all b
308: WHERE a.tax_id = b.tax_id
309: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
310: AND ( ( pn_transaction_dist_id IS NOT NULL