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_description, service_level_id from vbs_service_levels select default_name, iso from countries select shipping_rate_id from vbs_rates where shipping_rate_id = :shipping_rate_id update vbs_rates set shipping_rate_id = :shipping_rate_id, service_level_id = :service_level_id, country_iso = :country_iso, from_value = :from_value, to_value = :to_value, from_zip_code = :from_zip_code, to_zip_code = :to_zip_code, shipping_rate = :shipping_rate where shipping_rate_id = :shipping_rate_id select shipping_rate_id, service_level_id, country_iso, round(from_value, 2) as from_value, round(to_value, 2) as to_value, from_zip_code, to_zip_code, round(shipping_rate, 2) as shipping_rate from vbs_rates where shipping_rate_id = :shipping_rate_id select shipping_rate_id from vbs_rates where service_level_id = :service_level_id and country_iso = :country_iso and from_value = :from_value and to_value = :to_value and from_zip_code = :from_zip_code and to_zip_code = :to_zip_code insert into vbs_rates (shipping_rate_id, service_level_id, country_iso, from_value, to_value, from_zip_code, to_zip_code, shipping_rate) values (:shipping_rate_id, :service_level_id, :country_iso, :from_value, :to_value, :from_zip_code, :to_zip_code, :shipping_rate)