TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DELETE_BUSINESSPROCESSINSTANCE (Trigger)

                
                CREATE trigger TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DELETE_BUSINESSPROCESSINSTANCE on dbo.PLANNEDGIFTACKNOWLEDGEMENTPROCESS after delete not for replication
                as begin
                    delete from dbo.BUSINESSPROCESSINSTANCE
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '8C332468-7D1F-4434-9ECD-C828FC3B6099';

                    delete from dbo.BUSINESSPROCESSCOMMPREF
                        where BUSINESSPROCESSPARAMETERSETID in (select ID from deleted) and BUSINESSPROCESSCATALOGID = '8C332468-7D1F-4434-9ECD-C828FC3B6099';

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