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.9.2.1 -r1.9.2.2
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	6 Dec 2002 21:04:19 -0000	1.9.2.1
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	17 Dec 2002 19:58:20 -0000	1.9.2.2
@@ -13,6 +13,7 @@
             where notifications.type_id = notification_requests.type_id
               and notifications.object_id = notification_requests.object_id
               and notifications.notification_id = notification_user_map.notification_id(+)
+              and notification_requests.user_id = notification_user_map.user_id(+)
               and sent_date is null
         </querytext>
     </fullquery>
@@ -35,6 +36,7 @@
               and interval_id = :interval_id
               and notifications.object_id = notification_requests.object_id
               and notifications.notification_id = notification_user_map.notification_id(+)
+              and notification_requests.user_id = notification_user_map.user_id(+)
               and sent_date is null
               and notification_requests_object.object_id = notification_requests.request_id
               and notification_requests_object.creation_date <= notifications.notif_date