select t.transition_name, ot.pretty_name as workflow_name, t.trigger_type from wf_transitions t, acs_object_types ot where t.transition_key = :transition_key and t.workflow_key = :workflow_key and ot.object_type = t.workflow_key select estimated_minutes from wf_context_transition_info where workflow_key = :workflow_key and transition_key = :transition_key and context_key = 'default'