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.5 -r1.6
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	25 Jun 2002 18:58:06 -0000	1.5
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	28 Jun 2002 20:21:50 -0000	1.6
@@ -25,7 +25,7 @@
                    notif_text,
                    notif_html,
                    notification_requests.user_id,
-                   type_id,
+                   notification_requests.type_id,
                    acs_object.name(notifications.object_id) as object_name
             from notifications,
                  notification_requests,