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_code as orig_service_level_code from vbs_service_levels where service_level_id = :service_level_id update vbs_service_levels set service_level_code = :service_level_code, service_level_description = :service_level_description where service_level_id = :service_level_id insert into vbs_service_levels (service_level_id, service_level_code, service_level_description) values (:service_level_id, :service_level_code, :service_level_description)