-- approval_clear.sql    Clears Approval Records from APPROVAL, Allows approval_gather2.sql to select all cleared records again
--**Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences. The scripts and information are provided "as is" without warranty, implied or otherwise. Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:) 
-- change log
-- bknox 2/23/03 created

!date

SET ECHO ON
SET FEEDBACK ON
SET TERMOUT ON

-- Prior to Monday's First Gather Run
DELETE FROM approval
      WHERE approval_type = 'R'
        AND TRUNC(approval_activity_date) < TRUNC(SYSDATE-7);

!date

-- approval_clear.sql end