1
2

SELECT r_object_id FROM dm_workflow WHERE r_object_id IN 
(SELECT r_workflow_id FROM dmi_package WHERE any r_component_id ='<objectid>')