APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_PS_VER

Line 188: FROM igs_ps_ver ps

184: NVL(sca.class_standing_override,get_class_standing(sca.person_id,sca.course_cd,'N'))
185: = p_class_stand ) AND*/
186: (p_org_unit_cd IS NULL OR
187: EXISTS (SELECT 'X'
188: FROM igs_ps_ver ps
189: WHERE ps.course_cd = sca.course_cd AND
190: ps.version_number = sca.version_number AND
191: ((ps.responsible_org_unit_cd = p_org_unit_cd AND
192: ps.responsible_ou_start_dt = p_org_unit_start_dt) OR

Line 236: l_course_cd igs_ps_ver.course_cd%TYPE;

232:
233:
234: l_cal_type igs_ca_inst.cal_type%TYPE;
235: l_ci_seq_number igs_ca_inst.sequence_number%TYPE;
236: l_course_cd igs_ps_ver.course_cd%TYPE;
237: l_course_version igs_ps_ver.version_number%TYPE;
238: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
239: l_unit_version igs_ps_unit_ver.version_number%TYPE;
240: l_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE;

Line 237: l_course_version igs_ps_ver.version_number%TYPE;

233:
234: l_cal_type igs_ca_inst.cal_type%TYPE;
235: l_ci_seq_number igs_ca_inst.sequence_number%TYPE;
236: l_course_cd igs_ps_ver.course_cd%TYPE;
237: l_course_version igs_ps_ver.version_number%TYPE;
238: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
239: l_unit_version igs_ps_unit_ver.version_number%TYPE;
240: l_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE;
241: l_unit_set_version igs_en_unit_set.version_number%TYPE;