APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_TYPE

Line 4953: from igs_ps_type ct, igs_ps_ver cv

4949: AND OVERRIDE_IND = 'Y';
4950:
4951: CURSOR c_prog_award IS
4952: select NVL(AWARD_COURSE_IND,'N')
4953: from igs_ps_type ct, igs_ps_ver cv
4954: where cv.course_cd = p_course_Cd
4955: and cv.version_number = p_course_version
4956: and cv.course_type = ct.course_type;
4957:

Line 4967: v_prog_award_ind igs_ps_type.AWARD_COURSE_IND%TYPE;

4963: and uv.version_number = uoo.version_number
4964: and uoo.uoo_id = p_uoo_id;
4965:
4966: l_system_type igs_pe_person_types.system_type%TYPE ;
4967: v_prog_award_ind igs_ps_type.AWARD_COURSE_IND%TYPE;
4968: v_unit_award_ind igs_ps_unit_ver.AWARD_COURSE_ONLY_IND%TYPE;
4969: l_step_override_limit number;
4970: l_dummy VARCHAR2(1);
4971: