APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARX_2003_V

Line 9343: FROM igs_uc_ivstarx_2003_v

9339: ,RTRIM(pocc) pocc
9340: ,RTRIM(pocctext) pocctext
9341: ,RTRIM(socioeconomic) socioeconomic
9342: ,RTRIM(occbackground) occbackground
9343: FROM igs_uc_ivstarx_2003_v
9344: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
9345:
9346: -- get the max timestamp value of the hercules view
9347: CURSOR c_max_timestamp IS

Line 9349: FROM igs_uc_ivstarx_2003_v ;

9345:
9346: -- get the max timestamp value of the hercules view
9347: CURSOR c_max_timestamp IS
9348: SELECT MAX(timestamp)
9349: FROM igs_uc_ivstarx_2003_v ;
9350:
9351: -- Variables
9352: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9353: l_new_max_timestamp igs_uc_ivstarx_2003_v.timestamp%TYPE ;

Line 9353: l_new_max_timestamp igs_uc_ivstarx_2003_v.timestamp%TYPE ;

9349: FROM igs_uc_ivstarx_2003_v ;
9350:
9351: -- Variables
9352: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9353: l_new_max_timestamp igs_uc_ivstarx_2003_v.timestamp%TYPE ;
9354: l_count NUMBER ;
9355:
9356: l_appno igs_uc_istarx_ints.appno%TYPE;
9357: l_checkdigit NUMBER;