select criteria_id,
criteria_name,
description
from recruiting_criteria
where package_id = :package_id
and enabled_p = 't'
update recruiting_interviews
set should_hire_p = :should_hire_p,
comment = :comment
where interview_id = :interview_id
select r.rating
from recruiting_ratings r
where criteria_id = :criteria_id
and interview_id = :interview_id
delete
from recruiting_ratings
where interview_id = :interview_id