APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVSCHOOL_2003

Line 2641: FROM igs_uc_u_cvschool_2003

2637: ,mailsort
2638: ,RTRIM(townkey) townkey
2639: ,RTRIM(countykey) countykey
2640: ,RTRIM(countrycode) countrycode
2641: FROM igs_uc_u_cvschool_2003
2642: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
2643:
2644: -- get the max timestamp value of the hercules view
2645: CURSOR c_max_timestamp IS

Line 2647: FROM igs_uc_u_cvschool_2003 ;

2643:
2644: -- get the max timestamp value of the hercules view
2645: CURSOR c_max_timestamp IS
2646: SELECT MAX(timestamp)
2647: FROM igs_uc_u_cvschool_2003 ;
2648:
2649: -- Variables
2650: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2651: l_new_max_timestamp igs_uc_u_cvschool_2003.timestamp%TYPE ;

Line 2651: l_new_max_timestamp igs_uc_u_cvschool_2003.timestamp%TYPE ;

2647: FROM igs_uc_u_cvschool_2003 ;
2648:
2649: -- Variables
2650: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2651: l_new_max_timestamp igs_uc_u_cvschool_2003.timestamp%TYPE ;
2652: l_count NUMBER ;
2653:
2654: BEGIN
2655: -- set syncronization required to false