APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNREFERENCE_2006_V

Line 11925: FROM igs_uc_ivnreference_2006_v

11921: ,RTRIM(telephone) telephone
11922: ,RTRIM(fax) fax
11923: ,RTRIM(email) email
11924: ,statement statement
11925: FROM igs_uc_ivnreference_2006_v
11926: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11927:
11928: -- get the max timestamp value of the hercules view
11929: CURSOR c_max_timestamp IS

Line 11931: FROM igs_uc_ivnreference_2006_v ;

11927:
11928: -- get the max timestamp value of the hercules view
11929: CURSOR c_max_timestamp IS
11930: SELECT MAX(timestamp)
11931: FROM igs_uc_ivnreference_2006_v ;
11932:
11933: -- Variables
11934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11935: l_new_max_timestamp igs_uc_ivnreference_2006_v.timestamp%TYPE ;

Line 11935: l_new_max_timestamp igs_uc_ivnreference_2006_v.timestamp%TYPE ;

11931: FROM igs_uc_ivnreference_2006_v ;
11932:
11933: -- Variables
11934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11935: l_new_max_timestamp igs_uc_ivnreference_2006_v.timestamp%TYPE ;
11936: l_count NUMBER ;
11937:
11938: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11939: l_checkdigit NUMBER;