APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_N_CVNCOURSE_2007

Line 587: FROM igs_uc_n_cvncourse_2007

583: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
584: ,timestamp
585: ,RTRIM(shortname) shortname
586: ,RTRIM(longname) longname
587: FROM igs_uc_n_cvncourse_2007
588: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
589:
590: -- get the max timestamp value of the hercules view
591: CURSOR c_max_timestamp IS

Line 593: FROM igs_uc_n_cvncourse_2007 ;

589:
590: -- get the max timestamp value of the hercules view
591: CURSOR c_max_timestamp IS
592: SELECT MAX(timestamp)
593: FROM igs_uc_n_cvncourse_2007 ;
594:
595: -- Variables
596: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
597: l_new_max_timestamp igs_uc_n_cvncourse_2007.timestamp%TYPE ;

Line 597: l_new_max_timestamp igs_uc_n_cvncourse_2007.timestamp%TYPE ;

593: FROM igs_uc_n_cvncourse_2007 ;
594:
595: -- Variables
596: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
597: l_new_max_timestamp igs_uc_n_cvncourse_2007.timestamp%TYPE ;
598: l_count NUMBER ;
599:
600: BEGIN
601: -- set syncronization required to false