APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARN_2007_V

Line 8796: FROM igs_uc_ivnstarn_2007_v

8792: ,RTRIM(forenames) forenames
8793: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8794: ,birthdate
8795: ,sex
8796: FROM igs_uc_ivnstarn_2007_v
8797: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8798:
8799: -- get the max timestamp value of the hercules view
8800: CURSOR c_max_timestamp IS

Line 8802: FROM igs_uc_ivnstarn_2007_v ;

8798:
8799: -- get the max timestamp value of the hercules view
8800: CURSOR c_max_timestamp IS
8801: SELECT MAX(timestamp)
8802: FROM igs_uc_ivnstarn_2007_v ;
8803:
8804: -- Variables
8805: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8806: l_new_max_timestamp igs_uc_ivnstarn_2007_v.timestamp%TYPE ;

Line 8806: l_new_max_timestamp igs_uc_ivnstarn_2007_v.timestamp%TYPE ;

8802: FROM igs_uc_ivnstarn_2007_v ;
8803:
8804: -- Variables
8805: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8806: l_new_max_timestamp igs_uc_ivnstarn_2007_v.timestamp%TYPE ;
8807: l_count NUMBER ;
8808:
8809: l_appno igs_uc_istarn_ints.appno%TYPE;
8810: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;