APPS.JAI_OM_TAX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 225: JAI_CMN_TAXES_ALL d ,

221: )
222: tax_type_val,
223: d.adhoc_flag
224: FROM JAI_OM_OE_SO_TAXES c ,
225: JAI_CMN_TAXES_ALL d ,
226: jai_regime_tax_types_v rgm_tax_types \* added by ssumaith - bug# 4245053*\
227: WHERE c.line_id = p_line_id
228: AND c.header_id = p_header_id
229: AND c.tax_id = d.tax_id

Line 285: , Jai_Cmn_Taxes_All d

281: , d.mod_cr_percentage
282: , d.inclusive_tax_flag
283: FROM
284: Jai_Om_Oe_So_Taxes c
285: , Jai_Cmn_Taxes_All d
286: , Jai_Regime_Tax_Types_V rgm_tax_types /* added by ssumaith - bug# 4245053*/
287: WHERE c.line_id = p_line_id
288: AND c.header_id = p_header_id
289: AND c.tax_id = d.tax_id

Line 314: JAI_CMN_TAXES_ALL d ,

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

Line 371: , Jai_Cmn_Taxes_All d

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

Line 403: FROM jai_cmn_taxes_all

399:
400: /* Start Additions by mmurtuza for bug 14031594*/
401: CURSOR get_adhoc_flag(pn_tax_id NUMBER) IS
402: SELECT adhoc_flag
403: FROM jai_cmn_taxes_all
404: WHERE tax_id = pn_tax_id;
405:
406: lv_adhoc_flag VARCHAR2(1);
407: /* End Additions by mmurtuza for bug 14031594*/

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

490:
491: This needs to be used for the calculation of the taxes registered under vat regime.
492:
493: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
494: JAI_CMN_TAXES_ALL table based on the tax type column.
495:
496: A parameter p_vat_assessable_Value NUMBER DEFAULT 0 has been added to the procedure.
497:
498: Dependency due to this bug - Huge

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

2298: 'OTHER EXCISE', 1,
2299: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_Cess,1, \*Bug 5989740 bduvarag*\
2300: 'TDS', 2, 0)) tax_type_val,
2301: b.tax_type,nvl(b.rounding_factor,0) rounding_factor
2302: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b,jai_regime_tax_types_v aa
2303: WHERE a.header_id = p_header_id
2304: AND a.line_id = p_line_id
2305: AND a.tax_id = b.tax_id
2306: AND aa.tax_type(+) = b.tax_type

Line 2359: , Jai_Cmn_Taxes_All b

2355: , b.tax_type
2356: , nvl(b.rounding_factor,0) rounding_factor
2357: FROM
2358: Jai_Om_Oe_So_Taxes a
2359: , Jai_Cmn_Taxes_All b
2360: , Jai_Regime_Tax_Types_V aa
2361: WHERE a.header_id = p_header_id
2362: AND a.line_id = p_line_id
2363: AND a.tax_id = b.tax_id

Line 3471: From JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b

3467:
3468: /* commented by cbabu for Bug#2496481
3469: CURSOR order_tax_amount_Cur (p_header_id Number, p_line_id Number) IS
3470: Select sum(a.tax_amount)
3471: From JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b
3472: Where a.Header_ID = p_header_id
3473: and a.line_id = p_line_id
3474: and b.tax_id = a.tax_id
3475: and b.tax_type != 'TDS';