APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARA_2003_V

Line 5026: FROM igs_uc_ivstara_2003_v

5022: ,RTRIM(homepostcode) homepostcode
5023: ,RTRIM(homephone) homephone
5024: ,NULL homefax -- not used in hercules
5025: ,NULL homeemail -- not used in hercules
5026: FROM igs_uc_ivstara_2003_v
5027: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5028:
5029: -- get the max timestamp value of the hercules view
5030: CURSOR c_max_timestamp IS

Line 5032: FROM igs_uc_ivstara_2003_v ;

5028:
5029: -- get the max timestamp value of the hercules view
5030: CURSOR c_max_timestamp IS
5031: SELECT MAX(timestamp)
5032: FROM igs_uc_ivstara_2003_v ;
5033:
5034: -- Variables
5035: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5036: l_new_max_timestamp igs_uc_ivstara_2003_v.timestamp%TYPE ;

Line 5036: l_new_max_timestamp igs_uc_ivstara_2003_v.timestamp%TYPE ;

5032: FROM igs_uc_ivstara_2003_v ;
5033:
5034: -- Variables
5035: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5036: l_new_max_timestamp igs_uc_ivstara_2003_v.timestamp%TYPE ;
5037: l_count NUMBER ;
5038:
5039: BEGIN
5040: -- set syncronization required to false