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