APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVREFERENCE_2004_V

Line 11529: FROM igs_uc_ivreference_2004_v

11525: ,RTRIM(telephone) telephone
11526: ,RTRIM(fax) fax
11527: ,RTRIM(email) email
11528: ,statement statement
11529: FROM igs_uc_ivreference_2004_v
11530: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11531:
11532: -- get the max timestamp value of the hercules view
11533: CURSOR c_max_timestamp IS

Line 11535: FROM igs_uc_ivreference_2004_v ;

11531:
11532: -- get the max timestamp value of the hercules view
11533: CURSOR c_max_timestamp IS
11534: SELECT MAX(timestamp)
11535: FROM igs_uc_ivreference_2004_v ;
11536:
11537: -- Variables
11538: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11539: l_new_max_timestamp igs_uc_ivreference_2004_v.timestamp%TYPE ;

Line 11539: l_new_max_timestamp igs_uc_ivreference_2004_v.timestamp%TYPE ;

11535: FROM igs_uc_ivreference_2004_v ;
11536:
11537: -- Variables
11538: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11539: l_new_max_timestamp igs_uc_ivreference_2004_v.timestamp%TYPE ;
11540: l_count NUMBER ;
11541:
11542: BEGIN
11543: -- set syncronization required to false