APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_G_CVGCOURSE_2007

Line 483: FROM igs_uc_g_cvgcourse_2007

479: ,NVL(DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)),'*') campus
480: ,timestamp
481: ,RTRIM(SUBSTR(longname,1,20)) shortname
482: ,RTRIM(longname) longname
483: FROM igs_uc_g_cvgcourse_2007
484: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
485:
486: -- get the max timestamp value of the hercules view
487: CURSOR c_max_timestamp IS

Line 489: FROM igs_uc_g_cvgcourse_2007 ;

485:
486: -- get the max timestamp value of the hercules view
487: CURSOR c_max_timestamp IS
488: SELECT MAX(timestamp)
489: FROM igs_uc_g_cvgcourse_2007 ;
490:
491: -- Variables
492: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
493: l_new_max_timestamp igs_uc_g_cvgcourse_2007.timestamp%TYPE ;

Line 493: l_new_max_timestamp igs_uc_g_cvgcourse_2007.timestamp%TYPE ;

489: FROM igs_uc_g_cvgcourse_2007 ;
490:
491: -- Variables
492: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
493: l_new_max_timestamp igs_uc_g_cvgcourse_2007.timestamp%TYPE ;
494: l_count NUMBER ;
495:
496: BEGIN
497: -- set syncronization required to false