[Home] [Help]
5: -- global cursors and variables
6: -- Get the cycle information from defaults
7: CURSOR c_cyc_info 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