APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTARN_2007_V

Line 8546: FROM igs_uc_ivgstarn_2007_v

8542: ,RTRIM(forenames) forenames
8543: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8544: ,birthdate
8545: ,sex
8546: FROM igs_uc_ivgstarn_2007_v
8547: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8548:
8549: -- get the max timestamp value of the hercules view
8550: CURSOR c_max_timestamp IS

Line 8552: FROM igs_uc_ivgstarn_2007_v ;

8548:
8549: -- get the max timestamp value of the hercules view
8550: CURSOR c_max_timestamp IS
8551: SELECT MAX(timestamp)
8552: FROM igs_uc_ivgstarn_2007_v ;
8553:
8554: -- Variables
8555: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8556: l_new_max_timestamp igs_uc_ivgstarn_2007_v.timestamp%TYPE ;

Line 8556: l_new_max_timestamp igs_uc_ivgstarn_2007_v.timestamp%TYPE ;

8552: FROM igs_uc_ivgstarn_2007_v ;
8553:
8554: -- Variables
8555: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8556: l_new_max_timestamp igs_uc_ivgstarn_2007_v.timestamp%TYPE ;
8557: l_count NUMBER ;
8558:
8559: l_appno igs_uc_istarn_ints.appno%TYPE;
8560: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;