APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTARN_2006_V

Line 8422: FROM igs_uc_ivgstarn_2006_v

8418: ,RTRIM(forenames) forenames
8419: ,DECODE(RTRIM(surname),NULL, RPAD('*',LENGTH(surname),'*'), RTRIM(surname)) surname
8420: ,birthdate
8421: ,sex
8422: FROM igs_uc_ivgstarn_2006_v
8423: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8424:
8425: -- get the max timestamp value of the hercules view
8426: CURSOR c_max_timestamp IS

Line 8428: FROM igs_uc_ivgstarn_2006_v ;

8424:
8425: -- get the max timestamp value of the hercules view
8426: CURSOR c_max_timestamp IS
8427: SELECT MAX(timestamp)
8428: FROM igs_uc_ivgstarn_2006_v ;
8429:
8430: -- Variables
8431: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8432: l_new_max_timestamp igs_uc_ivgstarn_2006_v.timestamp%TYPE ;

Line 8432: l_new_max_timestamp igs_uc_ivgstarn_2006_v.timestamp%TYPE ;

8428: FROM igs_uc_ivgstarn_2006_v ;
8429:
8430: -- Variables
8431: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
8432: l_new_max_timestamp igs_uc_ivgstarn_2006_v.timestamp%TYPE ;
8433: l_count NUMBER ;
8434:
8435: l_appno igs_uc_istarn_ints.appno%TYPE;
8436: l_checkdigit igs_uc_istarn_ints.checkdigit%TYPE;