oracle8.1.6 select package_id from apm_packages p, (select object_id, parent_id from site_nodes n where (object_id is null or acs_permission.permission_p(object_id, :user_id, 'read') = 't') start with node_id = :root_id connect by prior node_id = parent_id) site_map where site_map.object_id = p.package_id (+) and package_key = 'news'