DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_UCAS_CONTROL

Line 12: CURSOR c_ucas_cycle (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS

8: SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
9: FROM igs_uc_defaults ;
10: g_cyc_info_rec c_cyc_info%ROWTYPE ;
11:
12: CURSOR c_ucas_cycle (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
13: SELECT entry_year
14: FROM igs_uc_ucas_control
15: WHERE system_code = cp_system_code
16: AND ucas_cycle = g_cyc_info_rec.configured_cycle;

Line 14: FROM igs_uc_ucas_control

10: g_cyc_info_rec c_cyc_info%ROWTYPE ;
11:
12: CURSOR c_ucas_cycle (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
13: SELECT entry_year
14: FROM igs_uc_ucas_control
15: WHERE system_code = cp_system_code
16: AND ucas_cycle = g_cyc_info_rec.configured_cycle;
17: c_ucas_cycle_rec c_ucas_cycle%ROWTYPE ;
18: