Index: openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/Attic/approval-expiration-procs-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-oracle.xql	6 Jun 2003 09:12:20 -0000	1.1.2.1
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="subsite::sweep_expired_approvals.select_expired_user_ids">      
+      <querytext>
+      
+        select u.user_id 
+        from   cc_users u, 
+               acs_objects relo
+        where  relo.object_id = u.rel_id
+        and    last_visit < sysdate - :days
+        and    relo.last_modified < sysdate - :days
+        and    u.member_state = 'approved'
+        
+      </querytext>
+</fullquery>
+ 
+</queryset>