APPS.IGS_UC_EXPORT_UCAS_PKG dependencies on IGS_UC_DEFAULTS

Line 38: FROM igs_uc_defaults ;

34: (reverse chronological order - newest change first)
35: ********************************************************************************/
36: CURSOR cur_cycle IS
37: SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
38: FROM igs_uc_defaults ;
39:
40: cur_cycle_rec cur_cycle%ROWTYPE;
41:
42: CURSOR cur_control (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS

Line 49: l_entry_year igs_uc_defaults.configured_cycle%TYPE;

45: WHERE system_code = cp_system_code
46: AND ucas_cycle = cur_cycle_rec.configured_cycle;
47:
48:
49: l_entry_year igs_uc_defaults.configured_cycle%TYPE;
50:
51: CURSOR cur_interface(cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
52: SELECT ucas_interface FROM igs_uc_cyc_defaults
53: WHERE ucas_cycle = cur_cycle_rec.configured_cycle