APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CYC_DEFAULTS

Line 20: CURSOR c_ucas_interface (cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS

16: AND ucas_cycle = g_cyc_info_rec.configured_cycle;
17: c_ucas_cycle_rec c_ucas_cycle%ROWTYPE ;
18:
19: -- Cursor to get the UCAS_INTERFACE
20: CURSOR c_ucas_interface (cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS
21: SELECT ucas_interface
22: FROM IGS_UC_CYC_DEFAULTS
23: WHERE system_code = cp_system_code
24: AND ucas_cycle = g_cyc_info_rec.configured_cycle;

Line 22: FROM IGS_UC_CYC_DEFAULTS

18:
19: -- Cursor to get the UCAS_INTERFACE
20: CURSOR c_ucas_interface (cp_system_code igs_uc_cyc_defaults.system_code%TYPE) IS
21: SELECT ucas_interface
22: FROM IGS_UC_CYC_DEFAULTS
23: WHERE system_code = cp_system_code
24: AND ucas_cycle = g_cyc_info_rec.configured_cycle;
25: c_ucas_interface_rec igs_uc_cyc_defaults.ucas_interface%TYPE;
26:

Line 25: c_ucas_interface_rec igs_uc_cyc_defaults.ucas_interface%TYPE;

21: SELECT ucas_interface
22: FROM IGS_UC_CYC_DEFAULTS
23: WHERE system_code = cp_system_code
24: AND ucas_cycle = g_cyc_info_rec.configured_cycle;
25: c_ucas_interface_rec igs_uc_cyc_defaults.ucas_interface%TYPE;
26:
27: -- get the timestamp value of the hercules views from cvrefammendment
28: -- modified by jbaber
29: -- added country and nationality so that 2003 version looks like 2007 version