APPS.IGS_AD_GEN_014 dependencies on IGS_AD_PRCS_CAT_V

Line 140: igs_ad_prcs_cat_v b

136:
137: CURSOR c_appl_type(p_admission_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
138: SELECT a.admission_application_type
139: FROM igs_ad_ss_appl_typ a,
140: igs_ad_prcs_cat_v b
141: WHERE a.closed_ind = 'N'
142: AND a.admission_cat = b.admission_cat
143: AND a.s_admission_process_type = b.s_admission_process_type
144: AND b.closed_ind ='N'