Index: openacs-4/packages/evaluation/www/admin/grades/distribution-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/Attic/distribution-edit-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/evaluation/www/admin/grades/distribution-edit-oracle.xql	4 Apr 2005 18:22:36 -0000	1.1
+++ openacs-4/packages/evaluation/www/admin/grades/distribution-edit-oracle.xql	16 Jun 2005 09:22:36 -0000	1.1.2.1
@@ -6,15 +6,18 @@
 <fullquery name="get_grade_tasks">      
       <querytext>
 
-		select task_name, 
-		weight as task_weight,
-		requires_grade_p,
-		task_id
-		from evaluation_tasksi
-		where grade_item_id = :grade_item_id
-		and content_revision.is_live(task_id) = 't'
+		select et.task_item_id,
+		et.task_name, 
+		et.weight as task_weight,
+		et.requires_grade_p,
+		et.task_id,
+		cri.live_revision
+		from evaluation_tasksi et, cr_items cri
+		where et.grade_item_id = :grade_item_id
+		and (cri.live_revision = et.task_id or cri.latest_revision = et.task_id)
+		and cri.item_id = et.task_item_id
    		order by task_name 
-	
+
       </querytext>
 </fullquery>