Index: openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql	30 Jan 2004 09:46:04 -0000	1.5
+++ openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2-2.0d1.sql	5 Feb 2004 10:35:51 -0000	1.6
@@ -162,7 +162,9 @@
     from   users u,
            workflow_deputies dep
     where  u.user_id = dep.user_id (+)
-      and  (sysdate between dep.start_date and  dep.end_date);
+      and  ((dep.start_date is null and dep.end_date is null) or
+             (sysdate between dep.start_date and  dep.end_date)
+           );
 
 -- Answers the question: What are the enabled and assigned actions and which role are they assigned to?
 -- Useful for showing the task list for a particular user or role.
