APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVCOURSE_2003

Line 369: FROM igs_uc_u_cvcourse_2003

365: ,RTRIM(validcurrent) validcurrent
366: ,RTRIM(validdefer) validdefer
367: ,RTRIM(jointadmission) jointadmission
368: ,RTRIM(openextra) openextra
369: FROM igs_uc_u_cvcourse_2003
370: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
371:
372: -- get the max timestamp value of the hercules view
373: CURSOR c_max_timestamp IS

Line 375: FROM igs_uc_u_cvcourse_2003 ;

371:
372: -- get the max timestamp value of the hercules view
373: CURSOR c_max_timestamp IS
374: SELECT MAX(timestamp)
375: FROM igs_uc_u_cvcourse_2003 ;
376:
377: -- Variables
378: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
379: l_new_max_timestamp igs_uc_u_cvcourse_2003.timestamp%TYPE ;

Line 379: l_new_max_timestamp igs_uc_u_cvcourse_2003.timestamp%TYPE ;

375: FROM igs_uc_u_cvcourse_2003 ;
376:
377: -- Variables
378: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
379: l_new_max_timestamp igs_uc_u_cvcourse_2003.timestamp%TYPE ;
380: l_count NUMBER ;
381:
382: BEGIN
383: -- set syncronization required to false