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 = :package_id))
select parent_id
from site_nodes
where node_id = :node_id
select parent_id
from site_nodes
where object_id = :package_id
select object_id
from site_nodes
where node_id = (select parent_id
from site_nodes
where object_id = :package_id)