APPS.JAI_PA_COSTING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 217: from JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b

213: a.tax_amount * decode( nvl(a.modvat_flag, 'N'), 'N', 1, (1- nvl(b.mod_cr_percentage,0)/100))
214: )
215: ),0) transaction_tax_amount
216: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
217: from JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b
218: where a.tax_id = b.tax_id
219: and (
220: ( pn_transaction_dist_id is not null and a.requisition_line_id = r_get_reqn_dist_dtl.requisition_line_id )
221: or (pn_transaction_dist_id is null and a.requisition_header_id = pn_transaction_header_id)

Line 242: , jai_cmn_taxes_all b

238: ln_func_inclu_reco_tax_amt
239: , ln_trx_inclu_reco_tax_amt
240: FROM
241: jai_po_req_line_taxes a
242: , jai_cmn_taxes_all b
243: WHERE a.tax_id = b.tax_id
244: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
245: AND ( ( pn_transaction_dist_id IS NOT NULL
246: AND

Line 305: from JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

301: a.tax_amount * decode( nvl(a.modvat_flag, 'N'), 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100))
302: )
303: ),0) transaction_tax_amount
304: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
305: from JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
306: where a.tax_id = b.tax_id
307: and (
308: ( pn_transaction_dist_id is not null and a.line_location_id = r_get_po_dist_dtl.line_location_id )
309: or ( pn_transaction_dist_id is null and a.po_header_id = pn_transaction_header_id)

Line 330: , jai_cmn_taxes_all b

326: ln_func_inclu_reco_tax_amt
327: , ln_trx_inclu_reco_tax_amt
328: FROM
329: jai_po_taxes a
330: , jai_cmn_taxes_all b
331: WHERE a.tax_id = b.tax_id
332: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
333: AND ( ( pn_transaction_dist_id IS NOT NULL
334: AND

Line 449: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

445: )
446: )
447: ),0) transaction_tax_amount
448: into ln_func_nonreco_tax_amt, ln_trx_nonreco_tax_amt
449: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
450: where a.tax_id = b.tax_id
451: and (
452: -- ( pn_transaction_dist_id is not null and a.transaction_id = r_ja_in_deliver_trx.tax_transaction_id )
453: ( pn_transaction_dist_id is not null and a.shipment_line_id = r_ja_in_deliver_trx.shipment_line_id )

Line 480: , jai_cmn_taxes_all b

476: ln_func_inclu_reco_tax_amt
477: , ln_trx_inclu_reco_tax_amt
478: FROM
479: jai_rcv_line_taxes a
480: , jai_cmn_taxes_all b
481: WHERE a.tax_id = b.tax_id
482: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
483: AND ( ( pn_transaction_dist_id IS NOT NULL
484: -- AND a.transaction_id = r_ja_in_deliver_trx.tax_transaction_id )

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

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'
579: AND ( a.invoice_id, a.parent_invoice_distribution_id) =

Line 877: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

873: ),
874: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)
875: )
876: ),0) transaction_tax_amount
877: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
878: where a.tax_id = b.tax_id
879: and a.transaction_id = cp_tax_transaction_id;
880:
881: cursor c_ja_in_rcv_trx(cp_transaction_id in number) is