select count(*) from wf_workflows where workflow_key = :workflow_key select w.workflow_key, t.pretty_name from wf_workflows w, acs_object_types t where w.workflow_key = :workflow_key and w.workflow_key = t.object_type