APPS.IGS_PS_VAL_CFOS dependencies on IGS_PS_VER

Line 46: FROM IGS_PS_VER CV,

42: gv_course_f_o_s CHAR;
43: gv_course_status IGS_PS_STAT.s_course_status%TYPE;
44: CURSOR gc_course_status IS
45: SELECT CS.s_course_status
46: FROM IGS_PS_VER CV,
47: IGS_PS_STAT CS
48: WHERE CV.course_cd = p_course_cd AND
49: CV.version_number = p_version_number AND
50: CV.course_status = CS.course_status;

Line 127: FROM IGS_PS_VER CV,

123: v_course_status IGS_PS_STAT.s_course_status%TYPE;
124: v_count_records NUMBER;
125: CURSOR c_course_status IS
126: SELECT CS.s_course_status
127: FROM IGS_PS_VER CV,
128: IGS_PS_STAT CS
129: WHERE CV.course_cd = p_course_cd AND
130: CV.version_number = p_version_number AND
131: CV.course_status = CS.course_status;

Line 181: -- when no records are selected for the given IGS_PS_VER

177: CLOSE c_course_field_of_study;
178: p_message_name := NULL;
179: RETURN TRUE;
180: ELSE
181: -- when no records are selected for the given IGS_PS_VER
182: -- and the IGS_PS_STAT.s_unit_status is PLANNED
183: IF (v_course_status = 'PLANNED' AND v_count_records = 0) THEN
184: CLOSE c_course_status;
185: CLOSE c_course_field_of_study;

Line 190: -- record is selected for the given IGS_PS_VER with a

186: p_message_name := NULL;
187: RETURN TRUE;
188: ELSE
189: -- when none/more than one IGS_PS_FIELD_STUDY
190: -- record is selected for the given IGS_PS_VER with a
191: -- major_field_ind = 'Y' and the IGS_PS_STAT.s_unit_status
192: -- is not PLANNED
193: CLOSE c_course_status;
194: CLOSE c_course_field_of_study;