Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	29 Jun 2002 00:21:11 -0000	1.7
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	1 Jul 2002 19:35:30 -0000	1.8
@@ -37,6 +37,9 @@
             and notifications.object_id = notification_requests.object_id
             and notifications.notification_id = notification_user_map.notification_id(+)
             and sent_date is null
+            and notifications.notif_date <= 
+            (sysdate - (select n_seconds / 3600 / 24 from notification_intervals where interval_id= :interval_id))
+            order by notification_requests.user_id, notification_requests.type_id
         </querytext>
     </fullquery>