select instance_name from apm_packages where package_id= (select object_id from site_nodes where node_id= (select parent_id from site_nodes where object_id=:instance_id)) select parent_id from site_nodes where node_id = :node_id select parent_id from site_nodes where object_id = :instance_id select object_id from site_nodes where node_id = (select parent_id from site_nodes where object_id = :instance_id)