APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARX_2006_V

Line 9575: FROM igs_uc_ivnstarx_2006_v

9571: ,timestamp
9572: ,ethnic
9573: ,numberdependants
9574: ,RTRIM(maritalstatus) maritalstatus
9575: FROM igs_uc_ivnstarx_2006_v
9576: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
9577:
9578: -- get the max timestamp value of the hercules view
9579: CURSOR c_max_timestamp IS

Line 9581: FROM igs_uc_ivnstarx_2006_v ;

9577:
9578: -- get the max timestamp value of the hercules view
9579: CURSOR c_max_timestamp IS
9580: SELECT MAX(timestamp)
9581: FROM igs_uc_ivnstarx_2006_v ;
9582:
9583: -- Variables
9584: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9585: l_new_max_timestamp igs_uc_ivnstarx_2006_v.timestamp%TYPE ;

Line 9585: l_new_max_timestamp igs_uc_ivnstarx_2006_v.timestamp%TYPE ;

9581: FROM igs_uc_ivnstarx_2006_v ;
9582:
9583: -- Variables
9584: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
9585: l_new_max_timestamp igs_uc_ivnstarx_2006_v.timestamp%TYPE ;
9586: l_count NUMBER ;
9587:
9588: l_appno igs_uc_istarx_ints.appno%TYPE;
9589: l_checkdigit NUMBER;