DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVREFSCHOOLTYPE_2003

Line 2268: FROM igs_uc_u_cvrefschooltype_2003 ;

2264: -- or get all the records in hercules view if the timestamp passed is null
2265: CURSOR c_cvschtyp IS
2266: SELECT DECODE(RTRIM(schooltype),NULL, RPAD('*',LENGTH(schooltype),'*'), RTRIM(schooltype)) schooltype
2267: ,RTRIM(schooltext) schooltext
2268: FROM igs_uc_u_cvrefschooltype_2003 ;
2269:
2270: -- Variables
2271: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2272: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.schooltype%TYPE ;