APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_AD_DEPLVL_PRG

Line 1132: CURSOR c_pec_program(cp_c_adm_appl_type igs_ad_deplvl_prg.admission_application_type%TYPE)

1128: )
1129: );
1130:
1131: -- Cursor for fetching positive enrollment criteria when defined at program level
1132: CURSOR c_pec_program(cp_c_adm_appl_type igs_ad_deplvl_prg.admission_application_type%TYPE)
1133: IS
1134: SELECT program_code,
1135: version_number,
1136: NULL course_type

Line 1137: FROM igs_ad_deplvl_prg

1133: IS
1134: SELECT program_code,
1135: version_number,
1136: NULL course_type
1137: FROM igs_ad_deplvl_prg
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

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,