oracle8.1.6
select package_key, acs_object.name(package_id) instance_name
from apm_packages
where package_id = :package_id
select p.parameter_id, p.parameter_name, p.package_key,
nvl(p.description, 'No Description') description,
v.attr_value,
nvl(p.section_name, 'No Section Name') section_name
from apm_parameters p, (select parameter_id, attr_value
from apm_parameter_values v
where v.package_id = :package_id) v
where p.parameter_id = v.parameter_id(+)
and p.package_key = (select package_key from apm_packages where package_id = :package_id)
$additional_sql