As long as they are in the same transaction, changes to table A do not need to be committed in order to be available to table B. Generally, people use explicit transactions to guarantee that they are in the same transaction.

Drew