DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARW_2004_V

Line 10690: FROM igs_uc_ivstarw_2004_v

10686: , NVL( choice4lost,'N') choice4lost
10687: , NVL( choice5lost,'N') choice5lost
10688: , NVL( choice6lost,'N') choice6lost
10689: , NVL( choice7lost,'N') choice7lost
10690: FROM igs_uc_ivstarw_2004_v
10691: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10692:
10693: -- get the max timestamp value of the hercules view
10694: CURSOR c_max_timestamp IS

Line 10696: FROM igs_uc_ivstarw_2004_v ;

10692:
10693: -- get the max timestamp value of the hercules view
10694: CURSOR c_max_timestamp IS
10695: SELECT MAX(timestamp)
10696: FROM igs_uc_ivstarw_2004_v ;
10697:
10698: -- Variables
10699: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10700: l_new_max_timestamp igs_uc_ivstarw_2004_v.timestamp%TYPE ;

Line 10700: l_new_max_timestamp igs_uc_ivstarw_2004_v.timestamp%TYPE ;

10696: FROM igs_uc_ivstarw_2004_v ;
10697:
10698: -- Variables
10699: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10700: l_new_max_timestamp igs_uc_ivstarw_2004_v.timestamp%TYPE ;
10701: l_count NUMBER ;
10702:
10703: l_appno igs_uc_istarw_ints.appno%TYPE;
10704: l_checkdigit NUMBER;