TR_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_DELETE_BUSINESSPROCESSINSTANCE (Trigger)

        
                create trigger TR_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS after delete not for replication
                as begin
                    delete from dbo.BUSINESSPROCESSINSTANCE
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = 'e2f6ff31-29ec-4480-b9a2-293c35fd2ca3';
                end