TR_CONSTITUENTRECOGNITIONPROCESS_DELETE_BUSINESSPROCESSINSTANCE

                CREATE trigger TR_CONSTITUENTRECOGNITIONPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.CONSTITUENTRECOGNITIONPROCESS after delete not for replication
                as begin
                    delete from dbo.BUSINESSPROCESSINSTANCE
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '7616D877-034B-45A2-AB6D-3FCB63157DE2';

                end