1024: FROM
1025: JAI_OM_OE_SO_TAXES tl,
1026: JAI_CMN_TAXES_ALL tc
1027: WHERE
1028: tc.tax_type = jai_constants.tax_type_modvat_recovery AND /*--'Modvat Recovery' Ramananda for removal of SQL LITERALs :bug#4428980*/
1029: tc.tax_id = tl.tax_id AND
1030: tl.line_id = p_line_id ;
1031:
1032: lv_exists VARCHAR2(1) ;
1071:
1072: WHEN OTHERS THEN
1073: /* Handle all unexpected errors. */
1074: p_error_msg := 'Unexpected error occured in function validate_excise_exemption - '||sqlerrm;
1075: return jai_constants.unexpected_error;
1076: END validate_excise_exemption;
1077:
1078: END jai_om_utils_pkg;