APPS.IGS_EN_VAL_SUA dependencies on IGS_AS_UNIT_MODE

Line 3071: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

3067: BEGIN
3068: DECLARE
3069: v_coo_rec_found BOOLEAN;
3070: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3071: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3072: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3073: v_other_detail VARCHAR(255);
3074: CURSOR c_coo(
3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS

Line 3111: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

3107: BEGIN
3108: DECLARE
3109: v_coo_rec_found BOOLEAN;
3110: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
3111: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3112: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3113: v_other_detail VARCHAR(255);
3114: CURSOR c_coo(
3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS

Line 3128: FROM IGS_AS_UNIT_MODE

3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';
3125: CURSOR c_unit_mode(
3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS
3127: SELECT s_unit_mode
3128: FROM IGS_AS_UNIT_MODE
3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;
3130: CURSOR c_attend_mode(
3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS
3132: SELECT govt_attendance_mode

Line 3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;

3125: CURSOR c_unit_mode(
3126: cp_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE) IS
3127: SELECT s_unit_mode
3128: FROM IGS_AS_UNIT_MODE
3129: WHERE IGS_AS_UNIT_MODE.unit_mode = cp_unit_mode;
3130: CURSOR c_attend_mode(
3131: cp_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE) IS
3132: SELECT govt_attendance_mode
3133: FROM IGS_EN_ATD_MODE