5450: ,mailsort
5451: ,RTRIM(telephone) telephone
5452: ,RTRIM(email) email
5453: ,RTRIM(homepostcode) homepostcode
5454: FROM igs_uc_ivgstara_2006_v
5455: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5456:
5457: -- get the max timestamp value of the hercules view
5458: CURSOR c_max_timestamp IS
5456:
5457: -- get the max timestamp value of the hercules view
5458: CURSOR c_max_timestamp IS
5459: SELECT MAX(timestamp)
5460: FROM igs_uc_ivgstara_2006_v ;
5461:
5462: -- Variables
5463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5464: l_new_max_timestamp igs_uc_ivgstara_2006_v.timestamp%TYPE ;
5460: FROM igs_uc_ivgstara_2006_v ;
5461:
5462: -- Variables
5463: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5464: l_new_max_timestamp igs_uc_ivgstara_2006_v.timestamp%TYPE ;
5465: l_count NUMBER ;
5466:
5467: l_appno igs_uc_istara_ints.appno%TYPE;
5468: l_checkdigit NUMBER;