APPS.IGS_AD_VAL_SCFT dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

Line 205: FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,

201: v_coousv VARCHAR2(1);
202: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';
203: CURSOR c_coousv IS
204: SELECT 'x'
205: FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,
206: IGS_EN_UNIT_SET us,
207: IGS_EN_UNIT_SET_STAT uss
208: WHERE coousv.unit_set_cd = p_unit_set_cd AND
209: coousv.us_version_number = p_us_version_number AND