Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-oracle.xql	25 Apr 2001 04:52:44 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/assignee-add-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,9 +9,14 @@
     select p.party_id,
            acs_object.name(p.party_id) as name,
            p.email
-    from   parties p
-    where  not exists (select 1 from wf_task_assignments ta where ta.task_id = :task_id and ta.party_id = p.party_id)
+      from parties p
+     where not exists (select 1 from wf_task_assignments ta where ta.task_id = :task_id and ta.party_id = p.party_id)
+       and 0 < (select count(*)
+                from   users u, party_approved_member_map m
+                where  m.party_id = p.party_id
+                and    u.user_id = m.member_id)
 
+
       </querytext>
 </fullquery>