[Home] [Help]
688: rtl.tax_amount * (NVL(jtc.mod_cr_percentage, 0)/100)
689: * 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)
690: ) tax_amount,
691: jtc.tax_account_id
692: FROM JAI_RCV_LINE_TAXES rtl,
693: JAI_CMN_TAXES_ALL jtc
694: WHERE jtc.tax_id = rtl.tax_id
695: AND shipment_line_id = p_shipment_line_id
696: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
861: ln_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
862: ln_non_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
863: ln_other_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
864: ln_conv_factor NUMBER;
865: lv_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag%type;
866: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
867:
868: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
869: select item_trading_flag,organization_type,excise_in_trading,item_excisable
895: nvl(jtc.inclusive_tax_flag, 'N') inclusive_tax_flag, -- Added by Jia Li for India tax inclusive on 2007/11/28
896: nvl(rtl.currency, 'INR') currency,
897: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
898: FROM
899: JAI_RCV_LINE_TAXES rtl,
900: JAI_CMN_TAXES_ALL jtc
901: WHERE
902: shipment_line_id = p_shipment_line_id
903: AND jtc.tax_id = rtl.tax_id
917: /*
918: Comparison below is due to the case where Excise in RG23D ='Y', Tax_Rec.Modvat_Flag will be N
919: as Item Modvat Flag in the setup is No.
920: As a result of this, Excise should not be added to Item cost and hence deciding the Modvat
921: Amount solely upon the Modvat Flag in JAI_RCV_LINE_TAXES is wrong.
922: Hence, a variable ( lv_tax_modvat_flag) is first set based on the above permutations
923: and then a decision of whether the Excise needs to be added or not is done based on this flag.
924: */
925: