select grade_plural_name,
grade_name,
weight as grade_weight,
grade_item_id
from evaluation_grades where grade_id = :grade_id
select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi,
et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p
from evaluation_tasksi et
where task_id = :task_id
select calendar_id
from calendars
where private_p = 'f' and package_id = :community_package_id
select cal_item_id
from evaluation_cal_task_map
where task_item_id = :item_id
insert into evaluation_cal_task_map (
task_item_id,
cal_item_id
) values
(
:item_id,
:cal_item_id
)
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id