oracle8.1.6
select package_id,
ap.package_key,
acs_object.name(package_id) as instance_name,
apm_package_type.num_parameters(ap.package_key) as parameter_count
from apm_packages ap,
apm_package_types
where ap.package_key = apm_package_types.package_key
and package_type = 'apm_service'
and (
acs_permission.permission_p(package_id, :user_id, 'read') = 't'
or acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't'
)
and (ap.package_key != 'acs-subsite' or (select parent_id from site_nodes where object_id = package_id) is null)
order by instance_name