APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVCONTACT_2003

Line 2938: FROM igs_uc_u_uvcontact_2003

2934: ,RTRIM(address4) address4
2935: ,RTRIM(telephone) telephone
2936: ,RTRIM(email) email
2937: ,RTRIM(fax) fax
2938: FROM igs_uc_u_uvcontact_2003
2939: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
2940:
2941: -- get the max timestamp value of the hercules view
2942: CURSOR c_max_timestamp IS

Line 2944: FROM igs_uc_u_uvcontact_2003 ;

2940:
2941: -- get the max timestamp value of the hercules view
2942: CURSOR c_max_timestamp IS
2943: SELECT MAX(timestamp)
2944: FROM igs_uc_u_uvcontact_2003 ;
2945:
2946: -- Variables
2947: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2948: l_new_max_timestamp igs_uc_u_uvcontact_2003.timestamp%TYPE ;

Line 2948: l_new_max_timestamp igs_uc_u_uvcontact_2003.timestamp%TYPE ;

2944: FROM igs_uc_u_uvcontact_2003 ;
2945:
2946: -- Variables
2947: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2948: l_new_max_timestamp igs_uc_u_uvcontact_2003.timestamp%TYPE ;
2949: l_count NUMBER ;
2950:
2951: BEGIN
2952: -- set syncronization required to false