APPS.IGS_EN_SEVIS dependencies on IGS_EN_ATD_TYPE_LOAD

Line 155: SELECT attendance_type FROM igs_en_atd_type_load

151:
152:
153: -- Cursor to get the attendance type for the maximum enrollment load
154: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
155: SELECT attendance_type FROM igs_en_atd_type_load
156: WHERE cal_type = l_cal_type
157: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
158: FROM igs_en_atd_type_load
159: WHERE cal_type = l_cal_type);

Line 158: FROM igs_en_atd_type_load

154: CURSOR c_att_type(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
155: SELECT attendance_type FROM igs_en_atd_type_load
156: WHERE cal_type = l_cal_type
157: AND lower_enr_load_range = (SELECT MAX(lower_enr_load_range)
158: FROM igs_en_atd_type_load
159: WHERE cal_type = l_cal_type);
160:
161: rec_teach_to_load cur_teach_to_load%ROWTYPE;
162: v_begin_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 178: l_att_type igs_en_atd_type_load.attendance_type%TYPE;

174: v_creation_dt DATE;
175: l_api_person_id igs_pe_alt_pers_id_v.api_person_id%TYPE;
176: l_description igs_ca_inst_all.description%TYPE;
177: l_cal_cat igs_ca_type.s_cal_cat%TYPE;
178: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
179:
180:
181: BEGIN
182:

Line 431: FROM igs_en_atd_type_load

427: --This is the way to get the Attendance Type for the Maximum lower enrollment load range
428: --in the provided load calendar, Which will be treated as the Full Time Attendance Type
429: CURSOR c_att_type ( p_cal_type igs_ca_inst_all.cal_type%TYPE ) IS
430: SELECT attendance_type
431: FROM igs_en_atd_type_load
432: WHERE cal_type = p_cal_type
433: AND lower_enr_load_range = ( SELECT MAX(lower_enr_load_range)
434: FROM igs_en_atd_type_load
435: WHERE cal_type = p_cal_type );

Line 434: FROM igs_en_atd_type_load

430: SELECT attendance_type
431: FROM igs_en_atd_type_load
432: WHERE cal_type = p_cal_type
433: AND lower_enr_load_range = ( SELECT MAX(lower_enr_load_range)
434: FROM igs_en_atd_type_load
435: WHERE cal_type = p_cal_type );
436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;

432: WHERE cal_type = p_cal_type
433: AND lower_enr_load_range = ( SELECT MAX(lower_enr_load_range)
434: FROM igs_en_atd_type_load
435: WHERE cal_type = p_cal_type );
436: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;
439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
440: l_description igs_ca_inst_all.description%TYPE;

Line 441: l_att_type igs_en_atd_type_load.attendance_type%TYPE;

437:
438: l_cal_type igs_ca_inst_all.cal_type%TYPE;
439: l_sequence_number igs_ca_inst_all.sequence_number%TYPE;
440: l_description igs_ca_inst_all.description%TYPE;
441: l_att_type igs_en_atd_type_load.attendance_type%TYPE;
442: l_credit_points NUMBER;
443: l_fte NUMBER;
444:
445: