APPS.IGS_ST_GEN_001 dependencies on IGS_EN_ATD_MODE

Line 30: v_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;

26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';
27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';
28: v_unit_mode_count NUMBER;
29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
30: v_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
31: CURSOR c_count_unit_mode IS
32: SELECT COUNT(UNIQUE um.s_unit_mode)
33: FROM IGS_ST_GVT_STDNTLOAD gslo,
34: IGS_EN_ST_SNAPSHOT ess,

Line 88: cp_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE ) IS

84: um.unit_mode = ucl.unit_mode AND
85: gsc.submission_yr = gslo.submission_yr AND
86: gsc.submission_number = gslo.submission_number;
87: CURSOR c_get_attend_mode (
88: cp_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE ) IS
89: SELECT attendance_mode
90: FROM IGS_EN_ATD_MODE
91: WHERE govt_attendance_mode = cp_govt_attend_mode
92: ORDER

Line 90: FROM IGS_EN_ATD_MODE

86: gsc.submission_number = gslo.submission_number;
87: CURSOR c_get_attend_mode (
88: cp_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE ) IS
89: SELECT attendance_mode
90: FROM IGS_EN_ATD_MODE
91: WHERE govt_attendance_mode = cp_govt_attend_mode
92: ORDER
93: BY attendance_mode;
94: BEGIN