APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARN_2006_V

Line 8672: FROM igs_uc_ivnstarn_2006_v

8668: ,RTRIM(forenames) forenames
8669: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8670: ,birthdate
8671: ,sex
8672: FROM igs_uc_ivnstarn_2006_v
8673: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8674:
8675: -- get the max timestamp value of the hercules view
8676: CURSOR c_max_timestamp IS

Line 8678: FROM igs_uc_ivnstarn_2006_v ;

8674:
8675: -- get the max timestamp value of the hercules view
8676: CURSOR c_max_timestamp IS
8677: SELECT MAX(timestamp)
8678: FROM igs_uc_ivnstarn_2006_v ;
8679:
8680: -- Variables
8681: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8682: l_new_max_timestamp igs_uc_ivnstarn_2006_v.timestamp%TYPE ;

Line 8682: l_new_max_timestamp igs_uc_ivnstarn_2006_v.timestamp%TYPE ;

8678: FROM igs_uc_ivnstarn_2006_v ;
8679:
8680: -- Variables
8681: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8682: l_new_max_timestamp igs_uc_ivnstarn_2006_v.timestamp%TYPE ;
8683: l_count NUMBER ;
8684:
8685: l_appno igs_uc_istarn_ints.appno%TYPE;
8686: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;