APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVEBLSUBJECT_2003

Line 698: FROM igs_uc_u_cveblsubject_2003

694: ,RTRIM(externalref) externalref
695: ,DECODE(RTRIM(examlevel),NULL, RPAD('*',LENGTH(examlevel),'*'), RTRIM(examlevel)) examlevel
696: ,RTRIM(title) title
697: ,RTRIM(subjcode) subjcode
698: FROM igs_uc_u_cveblsubject_2003
699: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
700:
701: -- get the max timestamp value of the hercules view
702: CURSOR c_max_timestamp IS

Line 704: FROM igs_uc_u_cveblsubject_2003 ;

700:
701: -- get the max timestamp value of the hercules view
702: CURSOR c_max_timestamp IS
703: SELECT MAX(timestamp)
704: FROM igs_uc_u_cveblsubject_2003 ;
705:
706: -- Variables
707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
708: l_new_max_timestamp igs_uc_u_cveblsubject_2003.timestamp%TYPE ;

Line 708: l_new_max_timestamp igs_uc_u_cveblsubject_2003.timestamp%TYPE ;

704: FROM igs_uc_u_cveblsubject_2003 ;
705:
706: -- Variables
707: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
708: l_new_max_timestamp igs_uc_u_cveblsubject_2003.timestamp%TYPE ;
709: l_count NUMBER ;
710:
711:
712: BEGIN