APPS.IGS_EN_SEVIS dependencies on IGS_LOOKUPS_VIEW

Line 130: CURSOR c_sevis_meaning (l_lookup_code igs_lookups_view.lookup_code%TYPE) IS

126: WHERE cal_type = l_cal_type;
127:
128:
129: -- Get the sevis meaning for the passed sevis lookup code
130: CURSOR c_sevis_meaning (l_lookup_code igs_lookups_view.lookup_code%TYPE) IS
131: SELECT meaning
132: FROM igs_lookups_view
133: WHERE lookup_type = 'IGS_EN_SEVIS_AUTH_CODES'
134: AND lookup_code = l_lookup_code;

Line 132: FROM igs_lookups_view

128:
129: -- Get the sevis meaning for the passed sevis lookup code
130: CURSOR c_sevis_meaning (l_lookup_code igs_lookups_view.lookup_code%TYPE) IS
131: SELECT meaning
132: FROM igs_lookups_view
133: WHERE lookup_type = 'IGS_EN_SEVIS_AUTH_CODES'
134: AND lookup_code = l_lookup_code;
135:
136: -- Get the preferred alternate person id

Line 173: l_sevis_meaning igs_lookups_view.meaning%TYPE;

169: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
170: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
171: l_person_name_row c_person_name%ROWTYPE;
172: l_cal_type_row c_cal_type%ROWTYPE;
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;