APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVCOURSEVACOPS_2003

Line 3535: FROM igs_uc_u_uvcoursevacops_2003

3531: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater
3532: ,RTRIM(clupdated) clupdated
3533: ,cldate
3534: ,RTRIM(vacstatus) vacstatus
3535: FROM igs_uc_u_uvcoursevacops_2003
3536: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3537:
3538: -- get the max timestamp value of the hercules view
3539: CURSOR c_max_timestamp IS

Line 3541: FROM igs_uc_u_uvcoursevacops_2003 ;

3537:
3538: -- get the max timestamp value of the hercules view
3539: CURSOR c_max_timestamp IS
3540: SELECT MAX(timestamp)
3541: FROM igs_uc_u_uvcoursevacops_2003 ;
3542:
3543: -- Variables
3544: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3545: l_new_max_timestamp IGS_UC_U_UVCOURSEVACOPS_2003.timestamp%TYPE ;

Line 3545: l_new_max_timestamp IGS_UC_U_UVCOURSEVACOPS_2003.timestamp%TYPE ;

3541: FROM igs_uc_u_uvcoursevacops_2003 ;
3542:
3543: -- Variables
3544: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3545: l_new_max_timestamp IGS_UC_U_UVCOURSEVACOPS_2003.timestamp%TYPE ;
3546: l_count NUMBER ;
3547:
3548: BEGIN
3549: -- set syncronization required to false