You say ID is unique.  So after inserting the row into TableB and doing other updates, do you need to check the Status again before deleting?  It's only going to be that one row, correct?

Now the question becomes, what do you want to happen if Status changed during the time the SP was running?  Do a Rollback to remove it from B and remove the other updates?  Or just go forward and delete it from A?