APPS.JAI_OM_TAX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 191: JAI_CMN_TAXES_ALL d ,

187: )
188: tax_type_val,
189: d.adhoc_flag
190: FROM JAI_OM_OE_SO_TAXES c ,
191: JAI_CMN_TAXES_ALL d ,
192: jai_regime_tax_types_v rgm_tax_types \* added by ssumaith - bug# 4245053*\
193: WHERE c.line_id = p_line_id
194: AND c.header_id = p_header_id
195: AND c.tax_id = d.tax_id

Line 249: , Jai_Cmn_Taxes_All d

245: , d.mod_cr_percentage
246: , d.inclusive_tax_flag
247: FROM
248: Jai_Om_Oe_So_Taxes c
249: , Jai_Cmn_Taxes_All d
250: , Jai_Regime_Tax_Types_V rgm_tax_types /* added by ssumaith - bug# 4245053*/
251: WHERE c.line_id = p_line_id
252: AND c.header_id = p_header_id
253: AND c.tax_id = d.tax_id

Line 278: JAI_CMN_TAXES_ALL d ,

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
282: AND rgm_tax_types.tax_type(+) = d.tax_type \* added by ssumaith - bug# 4245053*\

Line 333: , Jai_Cmn_Taxes_All d

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
337: AND rgm_tax_types.tax_type(+) = d.tax_type /* added by ssumaith - bug# 4245053*/

Line 425: JAI_CMN_TAXES_ALL table based on the tax type column.

421:
422: This needs to be used for the calculation of the taxes registered under vat regime.
423:
424: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
425: JAI_CMN_TAXES_ALL table based on the tax type column.
426:
427: A parameter p_vat_assessable_Value NUMBER DEFAULT 0 has been added to the procedure.
428:
429: Dependency due to this bug - Huge

Line 1599: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b,jai_regime_tax_types_v aa

1595: 'OTHER EXCISE', 1,
1596: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_Cess,1, \*Bug 5989740 bduvarag*\
1597: 'TDS', 2, 0)) tax_type_val,
1598: b.tax_type,nvl(b.rounding_factor,0) rounding_factor
1599: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b,jai_regime_tax_types_v aa
1600: WHERE a.header_id = p_header_id
1601: AND a.line_id = p_line_id
1602: AND a.tax_id = b.tax_id
1603: AND aa.tax_type(+) = b.tax_type

Line 1652: , Jai_Cmn_Taxes_All b

1648: , b.tax_type
1649: , nvl(b.rounding_factor,0) rounding_factor
1650: FROM
1651: Jai_Om_Oe_So_Taxes a
1652: , Jai_Cmn_Taxes_All b
1653: , Jai_Regime_Tax_Types_V aa
1654: WHERE a.header_id = p_header_id
1655: AND a.line_id = p_line_id
1656: AND a.tax_id = b.tax_id

Line 2419: From JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b

2415:
2416: /* commented by cbabu for Bug#2496481
2417: CURSOR order_tax_amount_Cur (p_header_id Number, p_line_id Number) IS
2418: Select sum(a.tax_amount)
2419: From JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
2420: Where a.Header_ID = p_header_id
2421: and a.line_id = p_line_id
2422: and b.tax_id = a.tax_id
2423: and b.tax_type != 'TDS';