TR_CONSTITUENTDUPLICATESEARCHPROCESS_DELETE_BUSINESSPROCESSINSTANCE

                create trigger TR_CONSTITUENTDUPLICATESEARCHPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.CONSTITUENTDUPLICATESEARCHPROCESS after delete not for replication
                as begin
                    delete from dbo.BUSINESSPROCESSINSTANCE
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = 'ecca871d-beb3-4649-9546-6d1e9676227c';

                end