APPS.IGS_PS_VAL_COUS dependencies on IGS_PS_COO_AD_UNIT_S

Line 85: -- IGS_PS_COO_AD_UNIT_S records exist for a IGS_PS_OF_OPT_AD_CAT for

81: -- * It ensures that the indicator can not be changed from 'N' to 'Y' once
82: -- IGS_PS_OF_UNT_SET_RL records exist with the
83: -- IGS_PS_OFR_UNIT_SET as the superior.
84: -- * It ensures that the indicator can not be changed from 'N' to 'Y' once
85: -- IGS_PS_COO_AD_UNIT_S records exist for a IGS_PS_OF_OPT_AD_CAT for
86: -- a IGS_PS_OFR_OPT
87: DECLARE
88: v_x VARCHAR2(1);
89: CURSOR c_cousr IS

Line 99: FROM IGS_PS_COO_AD_UNIT_S cacus

95: cousr.sup_unit_set_cd = p_unit_set_cd AND
96: cousr.sup_us_version_number = p_us_version_number;
97: CURSOR c_cacus IS
98: SELECT 'x'
99: FROM IGS_PS_COO_AD_UNIT_S cacus
100: WHERE cacus.course_cd = p_course_cd AND
101: cacus.crv_version_number = p_crv_version_number AND
102: cacus.cal_type = p_cal_type AND
103: cacus.unit_set_cd = p_unit_set_cd AND

Line 119: -- Validate against IGS_PS_COO_AD_UNIT_S

115: CLOSE c_cousr;
116: RETURN FALSE;
117: END IF;
118: CLOSE c_cousr;
119: -- Validate against IGS_PS_COO_AD_UNIT_S
120: OPEN c_cacus;
121: FETCH c_cacus INTO v_x;
122: IF (c_cacus%FOUND) THEN
123: CLOSE c_cacus;