select impl_name from acs_sc_impls, notification_delivery_methods where acs_sc_impls.impl_id = notification_delivery_methods.sc_impl_id and delivery_method_id= :delivery_method_id select delivery_method_id from notification_delivery_methods where short_name = :short_name update notification_delivery_methods set sc_impl_id = :sc_impl_id where delivery_method_id = :delivery_method_id