DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVSCHOOLCONTACT_2003

Line 2803: FROM igs_uc_u_cvschoolcontact_2003

2799: ,RTRIM(forms) forms
2800: ,RTRIM(referee) referee
2801: ,RTRIM(careers) careers
2802: ,RTRIM(eascontact) eascontact
2803: FROM igs_uc_u_cvschoolcontact_2003
2804: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
2805:
2806: -- get the max timestamp value of the hercules view
2807: CURSOR c_max_timestamp IS

Line 2809: FROM igs_uc_u_cvschoolcontact_2003 ;

2805:
2806: -- get the max timestamp value of the hercules view
2807: CURSOR c_max_timestamp IS
2808: SELECT MAX(timestamp)
2809: FROM igs_uc_u_cvschoolcontact_2003 ;
2810:
2811: -- Variables
2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;

Line 2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;

2809: FROM igs_uc_u_cvschoolcontact_2003 ;
2810:
2811: -- Variables
2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;
2814: l_count NUMBER ;
2815:
2816: BEGIN
2817: -- set syncronization required to false