TR_CORRESPONDENCEPROCESS_DELETE_BUSINESSPROCESSINSTANCE

CREATE trigger TR_CORRESPONDENCEPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.CORRESPONDENCEPROCESS after delete not for replication
as
begin
  delete from dbo.BUSINESSPROCESSINSTANCE
  where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '52776E74-DF72-451C-82D5-519549DAE34B';

  delete from dbo.BUSINESSPROCESSCOMMPREF
  where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '52776E74-DF72-451C-82D5-519549DAE34B';

  delete from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS
  where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted);
end