APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_DEFAULTS

Line 85: FROM igs_uc_defaults ;

81: -- smaddali added these cursors for bug#2669208 , ucfd203 build
82: -- Get the current and configured cycles from defaults table
83: CURSOR c_cycles IS
84: SELECT MAX(configured_cycle) configured_cycle, MAX(current_cycle) current_cycle
85: FROM igs_uc_defaults ;
86: g_c_cycles c_cycles%ROWTYPE ;
87:
88: -- get the cycle to which hercules is configured
89: CURSOR c_ucas_cycle IS

Line 211: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults

207: FROM igs_uc_load_mv_t
208: WHERE marvin_id = p_marvin_id - 1;
209:
210: -- Cursor to get the existing sequence number for the coresponding system
211: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
212: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
213: SELECT a.rowid , a.* , b.name
214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
215: WHERE a.system_code = b.system_code

Line 214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b

210: -- Cursor to get the existing sequence number for the coresponding system
211: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
212: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
213: SELECT a.rowid , a.* , b.name
214: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
215: WHERE a.system_code = b.system_code
216: AND a.system_code = cp_syscode
217: AND a.ucas_cycle = g_c_cycles.configured_cycle ;
218:

Line 289: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults

285: FROM igs_uc_load_mv_t
286: WHERE marvin_id = cp_marvin_id - 1;
287:
288: -- Cursor to get the existing sequence number for the coresponding system
289: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
290: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
291: SELECT a.rowid , a.* , b.name
292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
293: WHERE a.system_code = b.system_code

Line 292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b

288: -- Cursor to get the existing sequence number for the coresponding system
289: -- smaddali modified cursor for bug #2669208 , ucfd203 build, igs_uc_adm_systems is now merged with igs_uc_defaults
290: CURSOR c_cyc_defaults(cp_syscode igs_uc_cyc_defaults.system_code%TYPE) IS
291: SELECT a.rowid , a.* , b.name
292: FROM igs_uc_cyc_defaults a , igs_uc_defaults b
293: WHERE a.system_code = b.system_code
294: AND a.system_code = cp_syscode
295: AND a.ucas_cycle = g_c_cycles.configured_cycle ;
296: