APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_AD_DEPLVL_PRGTY

Line 1142: CURSOR c_pec_program_type(cp_c_adm_appl_type igs_ad_deplvl_prgty.admission_application_type%TYPE)

1138: WHERE admission_application_type = cp_c_adm_appl_type AND
1139: closed_ind='N';
1140:
1141: -- Cursor for fetching positive enrollment criteria when defined at program type level
1142: CURSOR c_pec_program_type(cp_c_adm_appl_type igs_ad_deplvl_prgty.admission_application_type%TYPE)
1143: IS
1144: SELECT NULL program_code,
1145: NULL version_number,
1146: program_type

Line 1147: FROM igs_ad_deplvl_prgty

1143: IS
1144: SELECT NULL program_code,
1145: NULL version_number,
1146: program_type
1147: FROM igs_ad_deplvl_prgty
1148: WHERE admission_application_type = cp_c_adm_appl_type AND
1149: closed_ind = 'N';
1150:
1151: -- table for holding all initial program attempts details,