APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_AS_UNIT_MODE

Line 2310: FROM IGS_AS_UNIT_MODE um,

2306: -- Cursor to fetch the system Unit mode once the Unit class is provided.
2307: CURSOR c_um_ucl (
2308: cp_sua_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2309: SELECT um.s_unit_mode
2310: FROM IGS_AS_UNIT_MODE um,
2311: IGS_AS_UNIT_CLASS ucl
2312: WHERE ucl.unit_class = cp_sua_unit_class AND
2313: ucl.closed_ind = 'N' AND
2314: ucl.unit_mode = um.unit_mode;

Line 2367: v_um_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

2363: l_return_value BOOLEAN;
2364: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2365: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2366: l_return_eftsu NUMBER := 0;
2367: v_um_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
2369:
2370: l_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2371: l_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;