Index: openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	23 Jan 2004 11:02:27 -0000	1.6
+++ openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	5 Feb 2004 10:37:33 -0000	1.7
@@ -14,15 +14,12 @@
              w.description_mime_type,
              a.short_name as initial_action,
              a.action_id as initial_action_id
-
-       TODO: Changed, see PG version
-        
       from   workflows w,
-             workflow_initial_action wia,
              workflow_actions a
       where  w.workflow_id = :workflow_id
-        and  wia.workflow_id = w.workflow_id (+)
-        and  a.action_id = wia.action_id (+)
+        and  w.workflow_id = a.workflow_id (+)
+        and  a.parent_action_id is null
+        and  (a.trigger_type = 'init' or a.trigger_type is null)
     </querytext>
   </fullquery>