APPS.JAI_PA_COSTING_PKG dependencies on JAI_PO_REQ_LINE_TAXES

Line 194: from JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b

190: a.tax_amount * decode( nvl(a.modvat_flag, 'N'), 'N', 1, (1- nvl(b.mod_cr_percentage,0)/100))
191: )
192: ),0) transaction_tax_amount
193: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
194: from JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b
195: where a.tax_id = b.tax_id
196: and (
197: ( pn_transaction_dist_id is not null and a.requisition_line_id = r_get_reqn_dist_dtl.requisition_line_id )
198: or (pn_transaction_dist_id is null and a.requisition_header_id = pn_transaction_header_id)

Line 218: jai_po_req_line_taxes a

214: INTO
215: ln_func_inclu_reco_tax_amt
216: , ln_trx_inclu_reco_tax_amt
217: FROM
218: jai_po_req_line_taxes a
219: , jai_cmn_taxes_all b
220: WHERE a.tax_id = b.tax_id
221: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
222: AND ( ( pn_transaction_dist_id IS NOT NULL