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, to_char(s.enroll_start, 'YYYY-MM-DD') as enroll_start, to_char(s.enroll_end, 'YYYY-MM-DD') as enroll_end, to_char(s.case_start, 'YYYY-MM-DD') as case_start, to_char(s.case_end, 'YYYY-MM-DD') as case_end, to_char(s.send_start_note_date, 'YYYY-MM-DD') as send_start_note_date, show_states_p, stylesheet from workflows w, sim_simulations s where w.workflow_id = :workflow_id and w.workflow_id = s.simulation_id