APPS.JAI_PA_COSTING_PKG dependencies on JAI_CMN_TAXES_ALL

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 219: , jai_cmn_taxes_all b

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
223: AND

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 307: , jai_cmn_taxes_all b

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
311: AND

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 457: , jai_cmn_taxes_all b

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
461: -- AND a.transaction_id = r_ja_in_deliver_trx.tax_transaction_id )

Line 533: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b

529: select
530: nvl(sum(a.base_amount),0) functional_tax_amount,
531: nvl(sum(a.tax_amount),0) transaction_tax_amount
532: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
533: from JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b
534: where a.tax_id = b.tax_id
535: and nvl(b.mod_cr_percentage, 0) = 0
536: and (a.invoice_id, a.parent_invoice_distribution_id) =
537: ( select invoice_id, invoice_distribution_id from ap_invoice_distributions_all

Line 552: , jai_cmn_taxes_all b

548: ln_func_inclu_reco_tax_amt
549: , ln_trx_inclu_reco_tax_amt
550: FROM
551: jai_ap_match_inv_taxes a
552: , jai_cmn_taxes_all b
553: WHERE a.tax_id = b.tax_id
554: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
555: AND a.recoverable_flag = 'Y'
556: AND ( a.invoice_id, a.parent_invoice_distribution_id) =