APPS.JAI_PA_COSTING_PKG dependencies on JAI_RCV_LINE_TAXES

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 479: jai_rcv_line_taxes a

475: INTO
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

Line 804: Cursor c_get_non_rec_taxes ( cp_tax_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%type,

800: and interface_id = p_xface_id;
801:
802: /*Bug 8400140 - Start*/
803:
804: Cursor c_get_non_rec_taxes ( cp_tax_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%type,
805: cp_attribute2 IN VARCHAR2,
806: cp_curr_conv_rate In NUMBER)
807: IS
808: select

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

Line 1977: FROM JAI_RCV_LINE_TAXES

1973: decode (modvat_flag, 'Y',0,tax_amount)/nvl(cp_curr_conv_rate,1),
1974: decode (modvat_flag, 'Y',0,tax_amount)
1975: )
1976: ,0) transaction_tax_amount
1977: FROM JAI_RCV_LINE_TAXES
1978: where ((cp_tax_type = 'VAT' AND tax_type in ( select tax_type
1979: from jai_regime_tax_types_v
1980: where regime_code = 'VAT'))
1981: OR