Understanding transaction isolation, locking, and deadlock prevention is essential for writing correct stored procedures. The deadlock prevention pattern used in PROC_TRANSFER_FUNDS originates here.