[Home] [Help]
143: A.BASE_TAX_AMOUNT BASE_TAX_AMT, --2001/03/30 Jagdish
144: b.tax_type t_type,
145: b.stform_type,
146: a.tax_line_no
147: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,
148: JAI_INV_ITM_SETUPS C
149: where link_to_cust_trx_line_id = p_line_id
150: and a.tax_id = b.tax_id
151: and c.inventory_item_id = p_inventory_item_id
192: --AND NVL(location_id,0) = NVL(v_location_id,0);
193:
194: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
195: SELECT a.tax_rate, b.rounding_factor
196: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
197: WHERE a.tax_id = b.tax_id
198: AND a.link_to_cust_trx_line_id = p_cust_trx_line_id
199: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /*'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
200: --added by GD
235: SELECT
236: sum(jrcttl.func_tax_amount) cess_amount
237: FROM
238: jai_ar_trx_lines jrctl ,
239: jai_ar_trx_tax_lines jrcttl ,
240: jai_cmn_taxes_all jtc
241: WHERE
242: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
243: jrcttl.tax_id = jtc.tax_id AND
252: SELECT
253: sum(jrcttl.func_tax_amount) sh_cess_amount
254: FROM
255: jai_ar_trx_lines jrctl,
256: jai_ar_trx_tax_lines jrcttl,
257: jai_cmn_taxes_all jtc
258: WHERE
259: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
260: jrcttl.tax_id = jtc.tax_id AND
891: nvl(pr_new.update_rg23d_flag,'N') = 'Y' /*bduvarag for the bug4601570*/
892: then
893: if nvl(v_item_trading_flag,'N') = 'Y' then
894: select sum(func_tax_amount) into v_duty_amount
895: from JAI_AR_TRX_TAX_LINES
896: where link_to_cust_trx_line_id=l_rec.customer_trx_line_id;
897: FOR match_rec IN matched_receipt_cur(l_rec.customer_trx_line_id)
898: LOOP
899: FOR rate_rec IN tax_rate_cur(l_rec.customer_trx_line_id,