Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql	3 May 2001 01:14:21 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/static-assignments-oracle.xql	14 May 2001 23:16:08 -0000	1.2
@@ -30,5 +30,22 @@
 
       </querytext>
 </fullquery>
+
+<fullquery name="parties">      
+      <querytext>
+      
+            select p.party_id as sel_party_id,
+                   acs_object.name(p.party_id) as sel_name,
+                   p.email as sel_email
+            from   parties p
+            where  p.party_id not in 
+                  (select ca.party_id 
+                   from   wf_context_assignments ca
+                   where  ca.workflow_key = :workflow_key 
+                   and    ca.context_key = :context_key 
+                   and    ca.transition_key = :transition_key)
+	
+      </querytext>
+</fullquery>
  
 </queryset>