APPS.IGS_EN_SEVIS dependencies on IGS_CA_TYPE

Line 125: FROM igs_ca_type

121: AND sequence_number = l_sequence_number;
122:
123: CURSOR c_cal_cat(l_cal_type igs_ca_inst_all.cal_type%TYPE) IS
124: SELECT s_cal_cat
125: FROM igs_ca_type
126: WHERE cal_type = l_cal_type;
127:
128:
129: -- Get the sevis meaning for the passed sevis lookup code

Line 177: l_cal_cat igs_ca_type.s_cal_cat%TYPE;

173: l_sevis_meaning igs_lookups_view.meaning%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