oracle8.1.6
select acs_object.name(:package_id) from dual
select site_node.url(n.node_id) as url, acs_object.name(n.object_id) as name
from site_nodes n
where n.parent_id = :node_id
and n.object_id is not null
and acs_permission.permission_p(n.object_id, :user_id, 'read') = 't'
order by name