APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARA_2007_V

Line 5872: FROM igs_uc_ivnstara_2007_v

5868: ,RTRIM(homepostcode) homepostcode
5869: ,RTRIM(mobile) mobile
5870: ,RTRIM(countrycode) countrycode
5871: ,RTRIM(homecountrycode) homecountrycode
5872: FROM igs_uc_ivnstara_2007_v
5873: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5874:
5875: -- get the max timestamp value of the hercules view
5876: CURSOR c_max_timestamp IS

Line 5878: FROM igs_uc_ivnstara_2007_v ;

5874:
5875: -- get the max timestamp value of the hercules view
5876: CURSOR c_max_timestamp IS
5877: SELECT MAX(timestamp)
5878: FROM igs_uc_ivnstara_2007_v ;
5879:
5880: -- Variables
5881: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5882: l_new_max_timestamp igs_uc_ivnstara_2007_v.timestamp%TYPE ;

Line 5882: l_new_max_timestamp igs_uc_ivnstara_2007_v.timestamp%TYPE ;

5878: FROM igs_uc_ivnstara_2007_v ;
5879:
5880: -- Variables
5881: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5882: l_new_max_timestamp igs_uc_ivnstara_2007_v.timestamp%TYPE ;
5883: l_count NUMBER ;
5884:
5885: l_appno igs_uc_istara_ints.appno%TYPE;
5886: l_checkdigit NUMBER;