deleting transaction must look at modifying_transaction ids as well