select w.workflow_id, w.short_name, w.pretty_name, w.object_id, w.package_key, w.object_type, w.description, s.suggested_duration, s.sim_type, s.enroll_type, s.casting_type, s.enroll_start, s.enroll_end, s.case_start, s.case_end, s.send_start_note_date from workflows w, sim_simulations s where w.workflow_id = :workflow_id and w.workflow_id = s.simulation_id