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 = 'email'