APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_OR_INSTITUTION

Line 229: CURSOR valid_inst_cur(l_cd igs_or_institution.institution_cd%TYPE) IS

225: WHERE admission_cat = cp_admission_cat AND
226: s_admission_process_type = cp_s_admission_process_type AND
227: step_group_type <> 'TRACK' ;
228:
229: CURSOR valid_inst_cur(l_cd igs_or_institution.institution_cd%TYPE) IS
230: SELECT institution_cd
231: FROM igs_or_institution
232: WHERE institution_cd = l_cd;
233:

Line 231: FROM igs_or_institution

227: step_group_type <> 'TRACK' ;
228:
229: CURSOR valid_inst_cur(l_cd igs_or_institution.institution_cd%TYPE) IS
230: SELECT institution_cd
231: FROM igs_or_institution
232: WHERE institution_cd = l_cd;
233:
234: CURSOR c_appl_inst_ctxt(
235: cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,

Line 400: l_inst_cd igs_or_institution.institution_cd%TYPE;

396: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
397: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
398:
399: l_applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
400: l_inst_cd igs_or_institution.institution_cd%TYPE;
401:
402: v_admission_cat igs_ad_appl.admission_cat%TYPE;
403: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
404: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

Line 823: -- Validations on Other Institution Code. It should be a valid institution_cd From IGS_OR_INSTITUTION table.

819: END IF;
820: END IF;
821:
822:
823: -- Validations on Other Institution Code. It should be a valid institution_cd From IGS_OR_INSTITUTION table.
824:
825: IF p_attent_other_inst_cd IS NOT NULL THEN
826: OPEN valid_inst_cur(p_attent_other_inst_cd);
827: FETCH valid_inst_cur INTO l_inst_cd;