APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARA_2007_V

Line 5310: FROM igs_uc_ivstara_2007_v

5306: ,RTRIM(homepostcode) homepostcode
5307: ,RTRIM(mobile) mobile
5308: ,RTRIM(countrycode) countrycode
5309: ,RTRIM(homecountrycode) homecountrycode
5310: FROM igs_uc_ivstara_2007_v
5311: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5312:
5313: -- get the max timestamp value of the hercules view
5314: CURSOR c_max_timestamp IS

Line 5316: FROM igs_uc_ivstara_2007_v ;

5312:
5313: -- get the max timestamp value of the hercules view
5314: CURSOR c_max_timestamp IS
5315: SELECT MAX(timestamp)
5316: FROM igs_uc_ivstara_2007_v ;
5317:
5318: -- Variables
5319: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5320: l_new_max_timestamp igs_uc_ivstara_2007_v.timestamp%TYPE ;

Line 5320: l_new_max_timestamp igs_uc_ivstara_2007_v.timestamp%TYPE ;

5316: FROM igs_uc_ivstara_2007_v ;
5317:
5318: -- Variables
5319: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5320: l_new_max_timestamp igs_uc_ivstara_2007_v.timestamp%TYPE ;
5321: l_count NUMBER ;
5322:
5323: l_appno igs_uc_istara_ints.appno%TYPE;
5324: l_checkdigit NUMBER;