APPS.JAI_OM_TAX_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 277: FROM JAI_OM_OE_RMA_TAXES c,

273: decode(upper(d.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0
274: )
275: ) tax_type_val,
276: d.adhoc_flag
277: FROM JAI_OM_OE_RMA_TAXES c,
278: JAI_CMN_TAXES_ALL d ,
279: jai_regime_tax_types_v rgm_tax_types \* added by ssumaith - bug# 4245053*\
280: WHERE c.rma_line_id = p_line_id
281: AND c.tax_id = d.tax_id

Line 332: Jai_Om_Oe_Rma_Taxes c

328: , d.vendor_id
329: , d.mod_cr_percentage
330: , d.inclusive_tax_flag
331: FROM
332: Jai_Om_Oe_Rma_Taxes c
333: , Jai_Cmn_Taxes_All d
334: , Jai_Regime_Tax_Types_V rgm_tax_types /* added by ssumaith - bug# 4245053*/
335: WHERE c.rma_line_id = p_line_id
336: AND c.tax_id = d.tax_id

Line 379: JAI_OM_OE_RMA_TAXES table .

375: to them, taxes were not getting recalculated.
376: Hence wrote code to get the same done by adding 2 cursors and checking
377: if the current header id and line id combination refers to a sales order
378: or rma order . if it corresponds to an rma order , update the
379: JAI_OM_OE_RMA_TAXES table .
380:
381: 4. 26-Feb-2004 Aiyer For the Bug #3590208 File Version 619.1
382: Issue:-
383: Excise Duty Recalculation happens for excise exempted tax lines if the order line quantity

Line 1472: UPDATE JAI_OM_OE_RMA_TAXES

1468:
1469: IF transaction_name = 'OE_LINES_UPDATE'
1470: THEN
1471:
1472: UPDATE JAI_OM_OE_RMA_TAXES
1473: SET tax_amount = nvl(tax_amt_tab(rec.lno),0),
1474: 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)),
1475: func_tax_amount = ROUND(nvl(tax_amt_tab(rec.lno),0) * v_currency_conv_factor, rounding_factor_tab(rec.lno) ),
1476: last_update_date = p_last_update_date,