APPS.IGS_AD_VAL_SCFT dependencies on IGS_EN_UNIT_SET_STAT

Line 202: cst_inactive CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'INACTIVE';

198: -- does not have a system status of 'INACTIVE' and maps to at least one
199: -- course_offering_unot_set or IGS_PS_OF_OPT_UNT_ST.
200: DECLARE
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,

Line 207: IGS_EN_UNIT_SET_STAT uss

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
210: coousv.course_cd = p_course_cd AND
211: coousv.crv_version_number = p_crv_version_number AND