APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_EN_ATD_MODE

Line 2321: FROM IGS_EN_ATD_MODE am

2317: -- Cursor to fetch the govt. Attendance mode from the user defined Attendance Mode. Government Attendance Mode of 1
2318: -- means ON CAMPUS , 2 means OFF CAMPUS and 3 means MIXED CAMPUS.
2319: CURSOR c_am ( cp_sca_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE) IS
2320: SELECT am.govt_attendance_mode
2321: FROM IGS_EN_ATD_MODE am
2322: WHERE am.attendance_mode = cp_sca_attendance_mode;
2323: --
2324: -- Cursor to check if the Organization Unit associated with the Course is the same as the Organization associated with the Unit.
2325: CURSOR c_cow (cp_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;

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;
2372: l_sca_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE;