APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARH_2003_V

Line 6542: FROM igs_uc_ivstarh_2003_v

6538: ,NULL lasteducation
6539: ,NULL educationleavedate
6540: ,NULL lea -- not used in hercules
6541: ,socialeconomic
6542: FROM igs_uc_ivstarh_2003_v
6543: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
6544:
6545: -- get the max timestamp value of the hercules view
6546: CURSOR c_max_timestamp IS

Line 6548: FROM igs_uc_ivstarh_2003_v ;

6544:
6545: -- get the max timestamp value of the hercules view
6546: CURSOR c_max_timestamp IS
6547: SELECT MAX(timestamp)
6548: FROM igs_uc_ivstarh_2003_v ;
6549:
6550: -- Variables
6551: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6552: l_new_max_timestamp igs_uc_ivstarh_2003_v.timestamp%TYPE ;

Line 6552: l_new_max_timestamp igs_uc_ivstarh_2003_v.timestamp%TYPE ;

6548: FROM igs_uc_ivstarh_2003_v ;
6549:
6550: -- Variables
6551: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
6552: l_new_max_timestamp igs_uc_ivstarh_2003_v.timestamp%TYPE ;
6553: l_count NUMBER ;
6554:
6555: l_appno igs_uc_istarh_ints.appno%TYPE;
6556: l_checkdigit NUMBER;