DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on JAI_CONSTANTS

Line 153: WHERE regime_code = jai_constants.vat_regime

149: /*bduvarag for the bug# 5256498 start*/
150: cursor c_check_Vat_type_Tax_exists (cp_tax_type VARCHAR2) IS
151: SELECT 1
152: FROM jai_regime_tax_types_v
153: WHERE regime_code = jai_constants.vat_regime
154: AND tax_type = cp_tax_type;
155:
156: lv_check_vat_type_exists VARCHAR2(1);
157:

Line 349: 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*/

345: FETCH c_check_Vat_type_Tax_exists INTO lv_check_vat_type_exists;
346: CLOSE c_check_Vat_type_Tax_exists;
347: /*bduvarag for the bug#5256498 end*/
348:
349: 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*/
350: v_excise_flag = 'N') OR
351: (tax_line_rec.tax_type IN ('Sales Tax', 'CST') AND
352: v_sales_flag = 'N') OR -- added, Harshita for bug#4245062
353: /*bduvarag for the bug#5256498 start*/