APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARW_2006_V

Line 11044: FROM igs_uc_ivnstarw_2006_v

11040: , timestamp
11041: , RTRIM(miscoded) miscoded
11042: , RTRIM(cancelled) cancelled
11043: , canceldate
11044: FROM igs_uc_ivnstarw_2006_v
11045: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11046:
11047: -- get the max timestamp value of the hercules view
11048: CURSOR c_max_timestamp IS

Line 11050: FROM igs_uc_ivnstarw_2006_v ;

11046:
11047: -- get the max timestamp value of the hercules view
11048: CURSOR c_max_timestamp IS
11049: SELECT MAX(timestamp)
11050: FROM igs_uc_ivnstarw_2006_v ;
11051:
11052: -- Variables
11053: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11054: l_new_max_timestamp igs_uc_ivnstarw_2006_v.timestamp%TYPE ;

Line 11054: l_new_max_timestamp igs_uc_ivnstarw_2006_v.timestamp%TYPE ;

11050: FROM igs_uc_ivnstarw_2006_v ;
11051:
11052: -- Variables
11053: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11054: l_new_max_timestamp igs_uc_ivnstarw_2006_v.timestamp%TYPE ;
11055: l_count NUMBER ;
11056:
11057: l_appno igs_uc_istarw_ints.appno%TYPE;
11058: l_checkdigit NUMBER;