APPS.IGS_AD_SS_GEN_001 dependencies on IGS_EN_CAT_MAPPING

Line 2158: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS

2154: AND admission_appl_number = cp_adm_appl_number;
2155: get_appl_dtl_rec get_appl_dtl%ROWTYPE;
2156:
2157: --tray Bug 2405076
2158: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS
2159: SELECT enrolment_cat
2160: FROM igs_en_cat_mapping
2161: WHERE admission_cat = cp_adm_cat
2162: AND dflt_cat_ind = 'Y';

Line 2160: FROM igs_en_cat_mapping

2156:
2157: --tray Bug 2405076
2158: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS
2159: SELECT enrolment_cat
2160: FROM igs_en_cat_mapping
2161: WHERE admission_cat = cp_adm_cat
2162: AND dflt_cat_ind = 'Y';
2163: get_enr_cat_rec get_enr_cat%ROWTYPE;
2164:

Line 2339: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS

2335: AND admission_appl_number = cp_adm_appl_number;
2336: get_appl_dtl_rec get_appl_dtl%ROWTYPE;
2337:
2338: --tray Bug 2405076
2339: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS
2340: SELECT enrolment_cat
2341: FROM igs_en_cat_mapping
2342: WHERE admission_cat = cp_adm_cat
2343: AND dflt_cat_ind = 'Y';

Line 2341: FROM igs_en_cat_mapping

2337:
2338: --tray Bug 2405076
2339: CURSOR get_enr_cat(cp_adm_cat igs_en_cat_mapping.admission_cat%TYPE) IS
2340: SELECT enrolment_cat
2341: FROM igs_en_cat_mapping
2342: WHERE admission_cat = cp_adm_cat
2343: AND dflt_cat_ind = 'Y';
2344: get_enr_cat_rec get_enr_cat%ROWTYPE;
2345: