APPS.IGS_PS_VAL_POS dependencies on IGS_EN_UNIT_SET_STAT

Line 159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:

155: RETURN TRUE;
156: END IF;
157: -- Check for IGS_PS_OFR_OPT records for the IGS_PS_COURSE offering supplied
158: -- and for IGS_EN_UNIT_SET versions with the uni_set_cd supplied which have a
159: -- IGS_EN_UNIT_SET_STAT.s_unit_set_status of ACTIVE:
160: OPEN c_coo;
161: FETCH c_coo INTO v_dummy;
162: IF (c_coo%NOTFOUND) THEN
163: -- no record found

Line 199: cst_active CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'ACTIVE';

195: BEGIN -- crsp_val_pos_cous
196: -- Warn the user if the IGS_EN_UNIT_SET is not linked to the IGS_PS_OFR.
197: -- Warning only.
198: DECLARE
199: cst_active CONSTANT IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE := 'ACTIVE';
200: v_dummy VARCHAR(1);
201: CURSOR c_cous_us_uss IS
202: SELECT 'X'
203: FROM IGS_PS_OFR_UNIT_SET cous,

Line 205: IGS_EN_UNIT_SET_STAT uss

201: CURSOR c_cous_us_uss IS
202: SELECT 'X'
203: FROM IGS_PS_OFR_UNIT_SET cous,
204: IGS_EN_UNIT_SET us,
205: IGS_EN_UNIT_SET_STAT uss
206: WHERE cous.course_cd = p_course_cd AND
207: cous.crv_version_number = p_crv_version_number AND
208: cous.cal_type = p_cal_type AND
209: cous.unit_set_cd = p_unit_set_cd AND

Line 517: IGS_EN_UNIT_SET_STAT uss

513: v_dummy VARCHAR2(1);
514: CURSOR c_us_uss IS
515: SELECT 'X'
516: FROM IGS_EN_UNIT_SET us,
517: IGS_EN_UNIT_SET_STAT uss
518: WHERE us.unit_set_cd = p_unit_set_cd AND
519: us.unit_set_status = uss.unit_set_status AND
520: uss.s_unit_set_status = 'ACTIVE';
521: BEGIN