APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVCONTGRP_2003

Line 3050: FROM igs_uc_u_uvcontgrp_2003

3046: SELECT DECODE(RTRIM(contactcode),NULL, RPAD('*',LENGTH(contactcode),'*'), RTRIM(contactcode)) contactcode
3047: ,ucasgroup
3048: ,RTRIM(updater) updater
3049: ,timestamp
3050: FROM igs_uc_u_uvcontgrp_2003
3051: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3052:
3053: -- get the max timestamp value of the hercules view
3054: CURSOR c_max_timestamp IS

Line 3056: FROM igs_uc_u_uvcontgrp_2003 ;

3052:
3053: -- get the max timestamp value of the hercules view
3054: CURSOR c_max_timestamp IS
3055: SELECT MAX(timestamp)
3056: FROM igs_uc_u_uvcontgrp_2003 ;
3057:
3058: -- Variables
3059: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3060: l_new_max_timestamp igs_uc_u_uvcontgrp_2003.timestamp%TYPE ;

Line 3060: l_new_max_timestamp igs_uc_u_uvcontgrp_2003.timestamp%TYPE ;

3056: FROM igs_uc_u_uvcontgrp_2003 ;
3057:
3058: -- Variables
3059: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3060: l_new_max_timestamp igs_uc_u_uvcontgrp_2003.timestamp%TYPE ;
3061: l_count NUMBER ;
3062:
3063: BEGIN
3064: -- set syncronization required to false