APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTARW_2006_V

Line 10819: FROM igs_uc_ivgstarw_2006_v

10815: , timestamp
10816: , RTRIM(miscoded) miscoded
10817: , RTRIM(cancelled) cancelled
10818: , canceldate
10819: FROM igs_uc_ivgstarw_2006_v
10820: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10821:
10822: -- get the max timestamp value of the hercules view
10823: CURSOR c_max_timestamp IS

Line 10825: FROM igs_uc_ivgstarw_2006_v ;

10821:
10822: -- get the max timestamp value of the hercules view
10823: CURSOR c_max_timestamp IS
10824: SELECT MAX(timestamp)
10825: FROM igs_uc_ivgstarw_2006_v ;
10826:
10827: -- Variables
10828: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10829: l_new_max_timestamp igs_uc_ivgstarw_2006_v.timestamp%TYPE ;

Line 10829: l_new_max_timestamp igs_uc_ivgstarw_2006_v.timestamp%TYPE ;

10825: FROM igs_uc_ivgstarw_2006_v ;
10826:
10827: -- Variables
10828: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10829: l_new_max_timestamp igs_uc_ivgstarw_2006_v.timestamp%TYPE ;
10830: l_count NUMBER ;
10831:
10832: l_appno igs_uc_istarw_ints.appno%TYPE;
10833: l_checkdigit NUMBER;