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)