Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/task-assignees-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/task-assignees-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/task-assignees-oracle.xql	25 Apr 2001 04:52:44 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/task-assignees-oracle.xql	19 Nov 2001 18:27:40 -0000	1.2
@@ -1,4 +1,5 @@
 <?xml version="1.0"?>
+
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
@@ -8,11 +9,14 @@
     select p.party_id,
            acs_object.name(p.party_id) as name,
            p.email,
-           '' as remove_url
+           '' as remove_url,
+           o.object_type
     from   wf_task_assignments ta,
-           parties p
+           parties p,
+           acs_objects o
     where  ta.task_id = :task_id
     and    p.party_id = ta.party_id
+    and    o.object_id = p.party_id
 
       </querytext>
 </fullquery>