APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_RCV_LINE_TAXES

Line 779: FROM JAI_RCV_LINE_TAXES rtl,

775: rtl.tax_amount * (NVL(jtc.mod_cr_percentage, 0)/100)
776: * decode(nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr), jai_rcv_trx_processing_pkg.gv_func_curr, 1, p_currency_conversion_rate)
777: ) tax_amount,
778: jtc.tax_account_id
779: FROM JAI_RCV_LINE_TAXES rtl,
780: JAI_CMN_TAXES_ALL jtc
781: WHERE jtc.tax_id = rtl.tax_id
782: AND shipment_line_id = p_shipment_line_id
783: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',

Line 960: lv_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag%type;

956: ln_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
957: ln_non_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
958: ln_other_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
959: ln_conv_factor NUMBER;
960: lv_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag%type;
961: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
962: ln_tax_amount NUMBER ; /* Added for bug #13494816 */
963:
964: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is

Line 996: JAI_RCV_LINE_TAXES rtl,

992: nvl(rtl.currency, 'INR') currency,
993: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage,
994: nvl(jtc.rounding_factor, 0) rounding_factor --Added for bug #13494816
995: FROM
996: JAI_RCV_LINE_TAXES rtl,
997: JAI_CMN_TAXES_ALL jtc
998: WHERE
999: shipment_line_id = p_shipment_line_id
1000: AND jtc.tax_id = rtl.tax_id

Line 1018: Amount solely upon the Modvat Flag in JAI_RCV_LINE_TAXES is wrong.

1014: /*
1015: Comparison below is due to the case where Excise in RG23D ='Y', Tax_Rec.Modvat_Flag will be N
1016: as Item Modvat Flag in the setup is No.
1017: As a result of this, Excise should not be added to Item cost and hence deciding the Modvat
1018: Amount solely upon the Modvat Flag in JAI_RCV_LINE_TAXES is wrong.
1019: Hence, a variable ( lv_tax_modvat_flag) is first set based on the above permutations
1020: and then a decision of whether the Excise needs to be added or not is done based on this flag.
1021: */
1022: