APPS.JAI_OM_TAX_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 313: FROM JAI_OM_OE_RMA_TAXES c,

309: decode(upper(d.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0
310: )
311: ) tax_type_val,
312: d.adhoc_flag
313: FROM JAI_OM_OE_RMA_TAXES c,
314: JAI_CMN_TAXES_ALL d ,
315: jai_regime_tax_types_v rgm_tax_types \* added by ssumaith - bug# 4245053*\
316: WHERE c.rma_line_id = p_line_id
317: AND c.tax_id = d.tax_id

Line 370: Jai_Om_Oe_Rma_Taxes c

366: , d.vendor_id
367: , d.mod_cr_percentage
368: , d.inclusive_tax_flag
369: FROM
370: Jai_Om_Oe_Rma_Taxes c
371: , Jai_Cmn_Taxes_All d
372: , Jai_Regime_Tax_Types_V rgm_tax_types /* added by ssumaith - bug# 4245053*/
373: WHERE c.rma_line_id = p_line_id
374: AND c.tax_id = d.tax_id

Line 448: JAI_OM_OE_RMA_TAXES table .

444: to them, taxes were not getting recalculated.
445: Hence wrote code to get the same done by adding 2 cursors and checking
446: if the current header id and line id combination refers to a sales order
447: or rma order . if it corresponds to an rma order , update the
448: JAI_OM_OE_RMA_TAXES table .
449:
450: 4. 26-Feb-2004 Aiyer For the Bug #3590208 File Version 619.1
451: Issue:-
452: Excise Duty Recalculation happens for excise exempted tax lines if the order line quantity

Line 2170: UPDATE JAI_OM_OE_RMA_TAXES

2166:
2167: IF transaction_name = 'OE_LINES_UPDATE'
2168: THEN
2169:
2170: UPDATE JAI_OM_OE_RMA_TAXES
2171: SET tax_amount = nvl(tax_amt_tab(rec.lno),0),
2172: base_tax_amount = decode(nvl(base_tax_amt_tab(rec.lno), 0), 0, nvl(tax_amt_tab(rec.lno),0), nvl(base_tax_amt_tab(rec.lno), 0)),
2173: func_tax_amount = ROUND(nvl(tax_amt_tab(rec.lno),0) * v_currency_conv_factor, rounding_factor_tab(rec.lno) ),
2174: last_update_date = p_last_update_date,