APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARA_2006_V

Line 5735: FROM igs_uc_ivnstara_2006_v

5731: ,mailsort
5732: ,RTRIM(telephone) telephone
5733: ,RTRIM(email) email
5734: ,RTRIM(homepostcode) homepostcode
5735: FROM igs_uc_ivnstara_2006_v
5736: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
5737:
5738: -- get the max timestamp value of the hercules view
5739: CURSOR c_max_timestamp IS

Line 5741: FROM igs_uc_ivnstara_2006_v ;

5737:
5738: -- get the max timestamp value of the hercules view
5739: CURSOR c_max_timestamp IS
5740: SELECT MAX(timestamp)
5741: FROM igs_uc_ivnstara_2006_v ;
5742:
5743: -- Variables
5744: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5745: l_new_max_timestamp igs_uc_ivnstara_2006_v.timestamp%TYPE ;

Line 5745: l_new_max_timestamp igs_uc_ivnstara_2006_v.timestamp%TYPE ;

5741: FROM igs_uc_ivnstara_2006_v ;
5742:
5743: -- Variables
5744: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
5745: l_new_max_timestamp igs_uc_ivnstara_2006_v.timestamp%TYPE ;
5746: l_count NUMBER ;
5747:
5748: l_appno igs_uc_istara_ints.appno%TYPE;
5749: l_checkdigit NUMBER;