APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTARA_2007_V

Line 5591: FROM igs_uc_ivgstara_2007_v

5587: ,RTRIM(homepostcode) homepostcode
5588: ,RTRIM(mobile) mobile
5589: ,RTRIM(countrycode) countrycode
5590: ,RTRIM(homecountrycode) homecountrycode
5591: FROM igs_uc_ivgstara_2007_v
5592: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5593:
5594: -- get the max timestamp value of the hercules view
5595: CURSOR c_max_timestamp IS

Line 5597: FROM igs_uc_ivgstara_2007_v ;

5593:
5594: -- get the max timestamp value of the hercules view
5595: CURSOR c_max_timestamp IS
5596: SELECT MAX(timestamp)
5597: FROM igs_uc_ivgstara_2007_v ;
5598:
5599: -- Variables
5600: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5601: l_new_max_timestamp igs_uc_ivgstara_2007_v.timestamp%TYPE ;

Line 5601: l_new_max_timestamp igs_uc_ivgstara_2007_v.timestamp%TYPE ;

5597: FROM igs_uc_ivgstara_2007_v ;
5598:
5599: -- Variables
5600: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5601: l_new_max_timestamp igs_uc_ivgstara_2007_v.timestamp%TYPE ;
5602: l_count NUMBER ;
5603:
5604: l_appno igs_uc_istara_ints.appno%TYPE;
5605: l_checkdigit NUMBER;