APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVGSTATEMENT_2006_V

Line 10246: FROM igs_uc_ivgstatement_2006_v

10242: -- Get all the records from hercules view whose timestamp is > passed timestamp
10243: -- or get all the records in hercules view if the timestamp passed is null
10244: CURSOR c_stmt (p_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ) IS
10245: SELECT appno,statement
10246: FROM igs_uc_ivgstatement_2006_v
10247: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
10248:
10249: -- get the max timestamp value of the hercules view
10250: CURSOR c_max_timestamp IS

Line 10252: FROM igs_uc_ivgstatement_2006_v ;

10248:
10249: -- get the max timestamp value of the hercules view
10250: CURSOR c_max_timestamp IS
10251: SELECT MAX(timestamp)
10252: FROM igs_uc_ivgstatement_2006_v ;
10253:
10254: -- Variables
10255: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10256: l_new_max_timestamp igs_uc_ivgstatement_2006_v.timestamp%TYPE ;

Line 10256: l_new_max_timestamp igs_uc_ivgstatement_2006_v.timestamp%TYPE ;

10252: FROM igs_uc_ivgstatement_2006_v ;
10253:
10254: -- Variables
10255: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
10256: l_new_max_timestamp igs_uc_ivgstatement_2006_v.timestamp%TYPE ;
10257: l_count NUMBER ;
10258:
10259: l_appno igs_uc_istmnt_ints.appno%TYPE;
10260: l_checkdigit NUMBER;