APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVOFFERABBREV_2003

Line 3865: FROM igs_uc_u_uvofferabbrev_2003

3861: ,RTRIM(abbrevtext) abbrevtext
3862: ,DECODE(RTRIM(letterformat),NULL, RPAD('*',LENGTH(letterformat),'*'), RTRIM(letterformat)) letterformat
3863: ,RTRIM(summarychar) summarychar
3864: ,abbrevuse
3865: FROM igs_uc_u_uvofferabbrev_2003
3866: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3867:
3868: -- get the max timestamp value of the hercules view
3869: CURSOR c_max_timestamp IS

Line 3871: FROM igs_uc_u_uvofferabbrev_2003 ;

3867:
3868: -- get the max timestamp value of the hercules view
3869: CURSOR c_max_timestamp IS
3870: SELECT MAX(timestamp)
3871: FROM igs_uc_u_uvofferabbrev_2003 ;
3872:
3873: -- Variables
3874: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3875: l_new_max_timestamp igs_uc_u_uvofferabbrev_2003.timestamp%TYPE ;

Line 3875: l_new_max_timestamp igs_uc_u_uvofferabbrev_2003.timestamp%TYPE ;

3871: FROM igs_uc_u_uvofferabbrev_2003 ;
3872:
3873: -- Variables
3874: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3875: l_new_max_timestamp igs_uc_u_uvofferabbrev_2003.timestamp%TYPE ;
3876: l_count NUMBER ;
3877:
3878: BEGIN
3879: -- set syncronization required to false