select p.instance_name from apm_packages p, apm_package_versions v where p.package_id = :package_id and p.package_key = v.package_key and v.enabled_p = 't' select service_level_id, service_level_code, service_level_description from vbs_service_levels where service_level_id = :service_level_id select service_level_id from vbs_rates where service_level_id = :service_level_id limit 1 delete from vbs_service_levels where service_level_id = :service_level_id