APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARN_2007_V

Line 8294: FROM igs_uc_ivstarn_2007_v

8290: ,RTRIM(forenames) forenames
8291: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8292: ,birthdate
8293: ,sex
8294: FROM igs_uc_ivstarn_2007_v
8295: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8296:
8297: -- get the max timestamp value of the hercules view
8298: CURSOR c_max_timestamp IS

Line 8300: FROM igs_uc_ivstarn_2007_v ;

8296:
8297: -- get the max timestamp value of the hercules view
8298: CURSOR c_max_timestamp IS
8299: SELECT MAX(timestamp)
8300: FROM igs_uc_ivstarn_2007_v ;
8301:
8302: -- Variables
8303: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8304: l_new_max_timestamp igs_uc_ivstarn_2007_v.timestamp%TYPE ;

Line 8304: l_new_max_timestamp igs_uc_ivstarn_2007_v.timestamp%TYPE ;

8300: FROM igs_uc_ivstarn_2007_v ;
8301:
8302: -- Variables
8303: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8304: l_new_max_timestamp igs_uc_ivstarn_2007_v.timestamp%TYPE ;
8305: l_count NUMBER ;
8306:
8307: l_appno igs_uc_istarn_ints.appno%TYPE;
8308: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;