APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVFORMQUALS_2006_V

Line 11394: FROM igs_uc_ivformquals_2006_v

11390: ,RTRIM(title) title
11391: ,RTRIM(grade) grade
11392: ,qualdateyear
11393: ,qualdatemonth
11394: FROM igs_uc_ivformquals_2006_v
11395: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11396:
11397: -- get the max timestamp value of the hercules view
11398: CURSOR c_max_timestamp IS

Line 11400: FROM igs_uc_ivformquals_2006_v ;

11396:
11397: -- get the max timestamp value of the hercules view
11398: CURSOR c_max_timestamp IS
11399: SELECT MAX(timestamp)
11400: FROM igs_uc_ivformquals_2006_v ;
11401:
11402: -- Variables
11403: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;

Line 11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;

11400: FROM igs_uc_ivformquals_2006_v ;
11401:
11402: -- Variables
11403: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11404: l_new_max_timestamp igs_uc_ivformquals_2006_v.timestamp%TYPE ;
11405: l_count NUMBER ;
11406:
11407: l_qualdate igs_uc_ifrmqul_ints.qualdate%TYPE;
11408: l_appno igs_uc_ifrmqul_ints.appno%TYPE;