DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on JAI_CONSTANTS

Line 171: WHERE regime_code = jai_constants.vat_regime

167: /*bduvarag for the bug# 5256498 start*/
168: cursor c_check_Vat_type_Tax_exists (cp_tax_type VARCHAR2) IS
169: SELECT 1
170: FROM jai_regime_tax_types_v
171: WHERE regime_code = jai_constants.vat_regime
172: AND tax_type = cp_tax_type;
173:
174: lv_check_vat_type_exists VARCHAR2(1);
175:

Line 367: IF (tax_line_rec.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS) AND /*Bug 5989740 bduvarag*/

363: FETCH c_check_Vat_type_Tax_exists INTO lv_check_vat_type_exists;
364: CLOSE c_check_Vat_type_Tax_exists;
365: /*bduvarag for the bug#5256498 end*/
366:
367: IF (tax_line_rec.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS) AND /*Bug 5989740 bduvarag*/
368: v_excise_flag = 'N') OR
369: (tax_line_rec.tax_type IN ('Sales Tax', 'CST') AND
370: v_sales_flag = 'N') OR -- added, Harshita for bug#4245062
371: /*bduvarag for the bug#5256498 start*/