TR_GIFTAIDREFRESHPROCESS_DELETE_BUSINESSPROCESSINSTANCE

                create trigger TR_GIFTAIDREFRESHPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.GIFTAIDREFRESHPROCESS after delete not for replication
                as begin
                    delete from dbo.BUSINESSPROCESSINSTANCE
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '9c973934-79a3-4a74-9ea5-fc432cfa7e9d';
                end