select instance_name from apm_packages where package_id = :package_id select m.group_id as supersite_group_id, p.instance_name as supersite_name from application_group_element_map m, apm_packages p where p.package_id = m.package_id and container_id = group_id and element_id = :subsite_group_id and rel_type = 'composition_rel' select count(*) from site_nodes where parent_id = :node_id and name = :instance_name select pretty_name from acs_object_types where object_type = :object_type