APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGREFERENCE_2006_V

Line 11791: FROM igs_uc_ivgreference_2006_v

11787: ,RTRIM(telephone) telephone
11788: ,RTRIM(fax) fax
11789: ,RTRIM(email) email
11790: ,statement statement
11791: FROM igs_uc_ivgreference_2006_v
11792: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11793:
11794: -- get the max timestamp value of the hercules view
11795: CURSOR c_max_timestamp IS

Line 11797: FROM igs_uc_ivgreference_2006_v ;

11793:
11794: -- get the max timestamp value of the hercules view
11795: CURSOR c_max_timestamp IS
11796: SELECT MAX(timestamp)
11797: FROM igs_uc_ivgreference_2006_v ;
11798:
11799: -- Variables
11800: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11801: l_new_max_timestamp igs_uc_ivgreference_2006_v.timestamp%TYPE ;

Line 11801: l_new_max_timestamp igs_uc_ivgreference_2006_v.timestamp%TYPE ;

11797: FROM igs_uc_ivgreference_2006_v ;
11798:
11799: -- Variables
11800: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11801: l_new_max_timestamp igs_uc_ivgreference_2006_v.timestamp%TYPE ;
11802: l_count NUMBER ;
11803:
11804: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11805: l_checkdigit NUMBER;