APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTATEMENT_2004_V

Line 10143: FROM igs_uc_ivstatement_2004_v

10139: -- Get all the records from hercules view whose timestamp is > passed timestamp
10140: -- or get all the records in hercules view if the timestamp passed is null
10141: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10142: SELECT appno,statement
10143: FROM igs_uc_ivstatement_2004_v
10144: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10145:
10146: -- get the max timestamp value of the hercules view
10147: CURSOR c_max_timestamp IS

Line 10149: FROM igs_uc_ivstatement_2004_v ;

10145:
10146: -- get the max timestamp value of the hercules view
10147: CURSOR c_max_timestamp IS
10148: SELECT MAX(timestamp)
10149: FROM igs_uc_ivstatement_2004_v ;
10150:
10151: -- Variables
10152: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10153: l_new_max_timestamp igs_uc_ivstatement_2004_v.timestamp%TYPE ;

Line 10153: l_new_max_timestamp igs_uc_ivstatement_2004_v.timestamp%TYPE ;

10149: FROM igs_uc_ivstatement_2004_v ;
10150:
10151: -- Variables
10152: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10153: l_new_max_timestamp igs_uc_ivstatement_2004_v.timestamp%TYPE ;
10154: l_count NUMBER ;
10155:
10156: l_appno igs_uc_istmnt_ints.appno%TYPE;
10157: l_checkdigit NUMBER;