select impl_name from acs_sc_impls, notification_types where type_id=:type_id and acs_sc_impls.impl_id=notification_types.sc_impl_id