DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVREFNATIONALITY_2007

Line 4358: FROM igs_uc_u_cvrefnationality_2007 ;

4354: -- or get all the records in hercules view if the timestamp passed is null
4355: CURSOR c_cvrefnationality IS
4356: SELECT DECODE(RTRIM(nationality),NULL, RPAD('*',LENGTH(nationality),'*'), RTRIM(nationality)) nationality
4357: ,RTRIM(description) description
4358: FROM igs_uc_u_cvrefnationality_2007 ;
4359:
4360: -- Variables
4361: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4362: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.nationality%TYPE ;