APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTARK_2007_V

Line 7642: FROM igs_uc_ivgstark_2007_v

7638: ,ukentrydate
7639: ,RTRIM(status) status
7640: ,firmnow
7641: ,extrastatus
7642: FROM igs_uc_ivgstark_2007_v
7643: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
7644:
7645: -- get the max timestamp value of the hercules view
7646: CURSOR c_max_timestamp IS

Line 7648: FROM igs_uc_ivgstark_2007_v ;

7644:
7645: -- get the max timestamp value of the hercules view
7646: CURSOR c_max_timestamp IS
7647: SELECT MAX(timestamp)
7648: FROM igs_uc_ivgstark_2007_v ;
7649:
7650: -- Variables
7651: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7652: l_new_max_timestamp igs_uc_ivgstark_2007_v.timestamp%TYPE ;

Line 7652: l_new_max_timestamp igs_uc_ivgstark_2007_v.timestamp%TYPE ;

7648: FROM igs_uc_ivgstark_2007_v ;
7649:
7650: -- Variables
7651: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
7652: l_new_max_timestamp igs_uc_ivgstark_2007_v.timestamp%TYPE ;
7653: l_count NUMBER ;
7654:
7655: l_appno igs_uc_istark_ints.appno%TYPE;
7656: l_checkdigit NUMBER;