select notification_id, notif_subject from notifications where notif_user = :user_id update notifications set notif_user = :to_user_id where notif_user = :from_user_id update notification_user_map set user_id = :to_user_id where user_id = :from_user_id insert into notification_email_hold (reply_id,to_addr,headers,body) values (:reply_id,:to_addr,:headers,:bodies) select sc.impl_owner_name as package_key from notification_types n, acs_sc_impls sc where n.sc_impl_id = sc.impl_id and n.type_id = :type_id limit 1