TR_PLEDGEREMINDERPROCESS_DELETE_BUSINESSPROCESSINSTANCE

        CREATE trigger TR_PLEDGEREMINDERPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.PLEDGEREMINDERPROCESS after delete not for replication
        as begin
          delete from dbo.BUSINESSPROCESSINSTANCE
            where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '84414BD2-3196-4697-998A-2493C29A302A';

          delete from dbo.BUSINESSPROCESSCOMMPREF
            where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '84414BD2-3196-4697-998A-2493C29A302A';

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