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 sn1.object_id
from site_nodes sn1,
apm_packages
where sn1.parent_id = (select sn2.node_id
from site_nodes sn2
where sn2.object_id = :parent_package_id)
and sn1.object_id = apm_packages.package_id
and apm_packages.package_key = :package_key