The person is very ill and wanted to leave monies to their heirs. Problem is, they don’t recall which banks they dealt with and are not sure where their passbooks are.

Do you walk into a bank with the proper papers (like a lawyer or executor of the will) and day “Did the Late John Doe have a bank account here?”
The state is California.