APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARZ2_2003_V

Line 9952: FROM igs_uc_ivstarz2_2003_v

9948: , DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)) campus
9949: , RTRIM(faculty) faculty
9950: , RTRIM(roundtype) roundtype
9951: , RTRIM(result) result
9952: FROM igs_uc_ivstarz2_2003_v
9953: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
9954:
9955: -- get the max timestamp value of the hercules view
9956: CURSOR c_max_timestamp IS

Line 9958: FROM igs_uc_ivstarz2_2003_v ;

9954:
9955: -- get the max timestamp value of the hercules view
9956: CURSOR c_max_timestamp IS
9957: SELECT MAX(timestamp)
9958: FROM igs_uc_ivstarz2_2003_v ;
9959:
9960: -- Variables
9961: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9962: l_new_max_timestamp igs_uc_ivstarz2_2003_v.timestamp%TYPE ;

Line 9962: l_new_max_timestamp igs_uc_ivstarz2_2003_v.timestamp%TYPE ;

9958: FROM igs_uc_ivstarz2_2003_v ;
9959:
9960: -- Variables
9961: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9962: l_new_max_timestamp igs_uc_ivstarz2_2003_v.timestamp%TYPE ;
9963: l_count NUMBER ;
9964:
9965: BEGIN
9966: -- set syncronization required to false