APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVOFFER_2003_V

Line 4543: FROM igs_uc_ivoffer_2003_v

4539: ,RTRIM(offerentrymonth) offerentrymonth
4540: ,RTRIM(offerentryyear) offerentryyear
4541: ,RTRIM(offerentrypoint) offerentrypoint
4542: ,RTRIM(offertext) offertext
4543: FROM igs_uc_ivoffer_2003_v
4544: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
4545:
4546: -- get the max timestamp value of the hercules view
4547: CURSOR c_max_timestamp IS

Line 4549: FROM igs_uc_ivoffer_2003_v ;

4545:
4546: -- get the max timestamp value of the hercules view
4547: CURSOR c_max_timestamp IS
4548: SELECT MAX(timestamp)
4549: FROM igs_uc_ivoffer_2003_v ;
4550:
4551: -- Variables
4552: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4553: l_new_max_timestamp igs_uc_ivoffer_2003_v.timestamp%TYPE ;

Line 4553: l_new_max_timestamp igs_uc_ivoffer_2003_v.timestamp%TYPE ;

4549: FROM igs_uc_ivoffer_2003_v ;
4550:
4551: -- Variables
4552: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4553: l_new_max_timestamp igs_uc_ivoffer_2003_v.timestamp%TYPE ;
4554: l_count NUMBER ;
4555:
4556: l_appno igs_uc_ioffer_ints.appno%TYPE;
4557: l_checkdigit NUMBER;