DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVREFOFFERSUBJ_2003

Line 1988: FROM igs_uc_u_cvrefoffersubj_2003 ;

1984: -- or get all the records in hercules view if the timestamp passed is null
1985: CURSOR c_cvoffsbj IS
1986: SELECT DECODE(RTRIM(subjcode),NULL, RPAD('*',LENGTH(subjcode),'*'), RTRIM(subjcode)) subjcode
1987: ,RTRIM(subjtext) subjtext
1988: FROM igs_uc_u_cvrefoffersubj_2003 ;
1989:
1990: -- Variables
1991: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
1992: l_new_max_timestamp igs_uc_u_cvrefamendments_2003.offersubjdate%TYPE ;