APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVNSTARH_2006_V

Line 6776: FROM igs_uc_ivnstarh_2006_v

6772: ,timestamp
6773: ,RTRIM(ethnic) ethnic
6774: ,numberdependants
6775: ,RTRIM(maritalstatus) maritalstatus
6776: FROM igs_uc_ivnstarh_2006_v
6777: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
6778:
6779: -- get the max timestamp value of the hercules view
6780: CURSOR c_max_timestamp IS

Line 6782: FROM igs_uc_ivnstarh_2006_v ;

6778:
6779: -- get the max timestamp value of the hercules view
6780: CURSOR c_max_timestamp IS
6781: SELECT MAX(timestamp)
6782: FROM igs_uc_ivnstarh_2006_v ;
6783:
6784: -- Variables
6785: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6786: l_new_max_timestamp igs_uc_ivnstarh_2006_v.timestamp%TYPE ;

Line 6786: l_new_max_timestamp igs_uc_ivnstarh_2006_v.timestamp%TYPE ;

6782: FROM igs_uc_ivnstarh_2006_v ;
6783:
6784: -- Variables
6785: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6786: l_new_max_timestamp igs_uc_ivnstarh_2006_v.timestamp%TYPE ;
6787: l_count NUMBER ;
6788:
6789: l_appno igs_uc_istarh_ints.appno%TYPE;
6790: l_checkdigit NUMBER;