oracle8.1.6 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' order by task_name