APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARN_2003_V

Line 8165: FROM igs_uc_ivstarn_2003_v

8161: ,RTRIM(forenames) forenames
8162: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8163: ,birthdate
8164: ,sex
8165: FROM igs_uc_ivstarn_2003_v
8166: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8167:
8168: -- get the max timestamp value of the hercules view
8169: CURSOR c_max_timestamp IS

Line 8171: FROM igs_uc_ivstarn_2003_v ;

8167:
8168: -- get the max timestamp value of the hercules view
8169: CURSOR c_max_timestamp IS
8170: SELECT MAX(timestamp)
8171: FROM igs_uc_ivstarn_2003_v ;
8172:
8173: -- Variables
8174: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8175: l_new_max_timestamp igs_uc_ivstarn_2003_v.timestamp%TYPE ;

Line 8175: l_new_max_timestamp igs_uc_ivstarn_2003_v.timestamp%TYPE ;

8171: FROM igs_uc_ivstarn_2003_v ;
8172:
8173: -- Variables
8174: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8175: l_new_max_timestamp igs_uc_ivstarn_2003_v.timestamp%TYPE ;
8176: l_count NUMBER ;
8177:
8178: l_appno igs_uc_istarn_ints.appno%TYPE;
8179: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;