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 -r1.14 -r1.15
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	28 Aug 2003 09:41:58 -0000	1.14
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	6 Sep 2006 18:11:56 -0000	1.15
@@ -19,6 +19,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
 	      and notification_user_map.sent_date is null
+	      and notifications.notif_date < sysdate()
         </querytext>
     </fullquery>
 
@@ -44,6 +45,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
               and notification_user_map.sent_date is null
+              and nnr.notif_date < sysdate()
               and acs_objects.object_id = nnr.request_id
               and acs_objects.creation_date <= nnr.notif_date
             order by nnr.user_id, nnr.type_id, nnr.notif_date