APPS.JAI_PA_COSTING_PKG dependencies on JAI_RCV_LINE_TAXES

Line 426: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

422: )
423: )
424: ),0) transaction_tax_amount
425: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
426: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
427: where a.tax_id = b.tax_id
428: and (
429: -- ( pn_transaction_dist_id is not null and a.transaction_id = r_ja_in_deliver_trx.tax_transaction_id )
430: ( pn_transaction_dist_id is not null and a.shipment_line_id = r_ja_in_deliver_trx.shipment_line_id )

Line 456: jai_rcv_line_taxes a

452: INTO
453: ln_func_inclu_reco_tax_amt
454: , ln_trx_inclu_reco_tax_amt
455: FROM
456: jai_rcv_line_taxes a
457: , jai_cmn_taxes_all b
458: WHERE a.tax_id = b.tax_id
459: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
460: AND ( ( pn_transaction_dist_id IS NOT NULL