APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARC_2006_V

Line 6220: FROM igs_uc_ivnstarc_2006_v

6216: ,datesubstituted
6217: ,DECODE(RTRIM(previousinst),NULL, RPAD('*',LENGTH(previousinst),'*'), RTRIM(previousinst)) previousinst
6218: ,DECODE(RTRIM(previouscourse),NULL, RPAD('*',LENGTH(previouscourse),'*'), RTRIM(previouscourse)) previouscourse
6219: ,DECODE(RTRIM(previouscampus),NULL, RPAD('*',LENGTH(previouscampus),'*'), RTRIM(previouscampus)) previouscampus
6220: FROM igs_uc_ivnstarc_2006_v
6221: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
6222:
6223: -- get the max timestamp value of the hercules view
6224: CURSOR c_max_timestamp IS

Line 6226: FROM igs_uc_ivnstarc_2006_v ;

6222:
6223: -- get the max timestamp value of the hercules view
6224: CURSOR c_max_timestamp IS
6225: SELECT MAX(timestamp)
6226: FROM igs_uc_ivnstarc_2006_v ;
6227:
6228: -- Variables
6229: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6230: l_new_max_timestamp igs_uc_ivnstarc_2006_v.timestamp%TYPE ;

Line 6230: l_new_max_timestamp igs_uc_ivnstarc_2006_v.timestamp%TYPE ;

6226: FROM igs_uc_ivnstarc_2006_v ;
6227:
6228: -- Variables
6229: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6230: l_new_max_timestamp igs_uc_ivnstarc_2006_v.timestamp%TYPE ;
6231: l_count NUMBER ;
6232:
6233: l_appno igs_uc_istarc_ints.appno%TYPE;
6234: l_checkdigit NUMBER;