APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_UVCOURSEKEYWORD_2003

Line 3297: FROM igs_uc_u_uvcoursekeyword_2003

3293: ,DECODE(RTRIM(keyword),NULL, RPAD('*',LENGTH(keyword),'*'), RTRIM(keyword)) keyword
3294: ,timestamp
3295: ,DECODE(RTRIM(updater),NULL, RPAD('*',LENGTH(updater),'*'), RTRIM(updater)) updater
3296: ,RTRIM(active) active
3297: FROM igs_uc_u_uvcoursekeyword_2003
3298: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3299:
3300: -- get the max timestamp value of the hercules view
3301: CURSOR c_max_timestamp IS

Line 3303: FROM igs_uc_u_uvcoursekeyword_2003 ;

3299:
3300: -- get the max timestamp value of the hercules view
3301: CURSOR c_max_timestamp IS
3302: SELECT MAX(timestamp)
3303: FROM igs_uc_u_uvcoursekeyword_2003 ;
3304:
3305: -- Variables
3306: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3307: l_new_max_timestamp igs_uc_u_uvcoursekeyword_2003.timestamp%TYPE ;

Line 3307: l_new_max_timestamp igs_uc_u_uvcoursekeyword_2003.timestamp%TYPE ;

3303: FROM igs_uc_u_uvcoursekeyword_2003 ;
3304:
3305: -- Variables
3306: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3307: l_new_max_timestamp igs_uc_u_uvcoursekeyword_2003.timestamp%TYPE ;
3308: l_count NUMBER ;
3309:
3310: BEGIN
3311: -- set syncronization required to false

Line 3335: FROM igs_uc_u_uvcoursekeyword_2003

3331: AND (course, campus, optioncode) IN (
3332: SELECT DISTINCT DECODE(RTRIM(course),NULL, RPAD('*',LENGTH(course),'*'), RTRIM(course)) course,
3333: DECODE(RTRIM(campus),NULL, RPAD('*',LENGTH(campus),'*'), RTRIM(campus)) campus,
3334: DECODE(RTRIM(optioncode),NULL, RPAD('*',LENGTH(optioncode),'*'), RTRIM(optioncode)) optioncode
3335: FROM igs_uc_u_uvcoursekeyword_2003
3336: WHERE (timestamp > p_old_timestamp OR p_old_timestamp IS NULL));
3337:
3338: -- create interface records for each record in the hercules view whose timestamp > old timestamp
3339: FOR c_uvcrsekyw_rec IN c_uvcrsekyw(p_old_timestamp) LOOP