TR_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS_DELETE

create trigger TR_UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS_DELETE on dbo.UPDATEMULTIPLECONSTITUENTFROMMFOPROCESSSTATUS with execute as owner after delete not for replication as  set nocount on;
 delete from dbo.BUSINESSPROCESSSTATUS where ID in (select ID from DELETED)