oracle8.1.6 select evaluation.party_id(:user_id,:task_id) from dual select round(ese.grade,2) as grade, ese.evaluation_id, ese.description as comments, ese.show_student_p, round((ese.grade*:t_weight*:g_weight)/10000,2) as task_grade from evaluation_student_evalsi ese, cr_items cri where ese.task_item_id = :task_item_id and cri.live_revision = ese.evaluation_id and ese.party_id = evaluation.party_id(:user_id,:task_id) select crr.filename as answer_data, crr.title as answer_title, ea.answer_id from evaluation_answers ea, cr_items cri, cr_revisions crr where ea.task_item_id = :task_item_id and cri.live_revision = ea.answer_id and crr.revision_id = ea.answer_id and ea.party_id = evaluation.party_id(:user_id,:task_id)