DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVINSTITUTION_2003

Line 3682: FROM igs_uc_u_uvinstitution_2003

3678: ,RTRIM(d3docsrequired) d3docsrequired
3679: ,RTRIM(clearingacceptcopyform) clearingacceptcopyform
3680: ,RTRIM(onlinemessage) onlinemessage
3681: ,RTRIM(ethniclistseq) ethniclistseq
3682: FROM igs_uc_u_uvinstitution_2003
3683: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3684:
3685: -- get the max timestamp value of the hercules view
3686: CURSOR c_max_timestamp IS

Line 3688: FROM igs_uc_u_uvinstitution_2003 ;

3684:
3685: -- get the max timestamp value of the hercules view
3686: CURSOR c_max_timestamp IS
3687: SELECT MAX(timestamp)
3688: FROM igs_uc_u_uvinstitution_2003 ;
3689:
3690: -- Variables
3691: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3692: l_new_max_timestamp igs_uc_u_uvinstitution_2003.timestamp%TYPE ;

Line 3692: l_new_max_timestamp igs_uc_u_uvinstitution_2003.timestamp%TYPE ;

3688: FROM igs_uc_u_uvinstitution_2003 ;
3689:
3690: -- Variables
3691: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3692: l_new_max_timestamp igs_uc_u_uvinstitution_2003.timestamp%TYPE ;
3693: l_count NUMBER ;
3694:
3695: BEGIN
3696: -- set syncronization required to false