APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVREFERENCE_2006_V

Line 11655: FROM igs_uc_ivreference_2006_v

11651: ,RTRIM(fax) fax
11652: ,RTRIM(email) email
11653: ,statement statement
11654: ,RTRIM(predictedgrades) predictedgrades
11655: FROM igs_uc_ivreference_2006_v
11656: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
11657:
11658: -- get the max timestamp value of the hercules view
11659: CURSOR c_max_timestamp IS

Line 11661: FROM igs_uc_ivreference_2006_v ;

11657:
11658: -- get the max timestamp value of the hercules view
11659: CURSOR c_max_timestamp IS
11660: SELECT MAX(timestamp)
11661: FROM igs_uc_ivreference_2006_v ;
11662:
11663: -- Variables
11664: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11665: l_new_max_timestamp igs_uc_ivreference_2006_v.timestamp%TYPE ;

Line 11665: l_new_max_timestamp igs_uc_ivreference_2006_v.timestamp%TYPE ;

11661: FROM igs_uc_ivreference_2006_v ;
11662:
11663: -- Variables
11664: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
11665: l_new_max_timestamp igs_uc_ivreference_2006_v.timestamp%TYPE ;
11666: l_count NUMBER ;
11667:
11668: l_appno igs_uc_irefrnc_ints.appno%TYPE;
11669: l_checkdigit NUMBER;