APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVFORMQUALS_2004_V

Line 11271: FROM igs_uc_ivformquals_2004_v

11267: ,RTRIM(awardbody) awardbody
11268: ,RTRIM(title) title
11269: ,RTRIM(grade) grade
11270: ,qualdate
11271: FROM igs_uc_ivformquals_2004_v
11272: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11273:
11274: -- get the max timestamp value of the hercules view
11275: CURSOR c_max_timestamp IS

Line 11277: FROM igs_uc_ivformquals_2004_v ;

11273:
11274: -- get the max timestamp value of the hercules view
11275: CURSOR c_max_timestamp IS
11276: SELECT MAX(timestamp)
11277: FROM igs_uc_ivformquals_2004_v ;
11278:
11279: -- Variables
11280: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11281: l_new_max_timestamp igs_uc_ivformquals_2004_v.timestamp%TYPE ;

Line 11281: l_new_max_timestamp igs_uc_ivformquals_2004_v.timestamp%TYPE ;

11277: FROM igs_uc_ivformquals_2004_v ;
11278:
11279: -- Variables
11280: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11281: l_new_max_timestamp igs_uc_ivformquals_2004_v.timestamp%TYPE ;
11282: l_count NUMBER ;
11283:
11284: l_appno igs_uc_ifrmqul_ints.appno%TYPE;
11285: l_checkdigit NUMBER;