Gordon,
I find it hard to see anything here that can cause a deadlock. You only
read values, and don't seem to update or delete anything. Maybe someone on
this list or ib-support could help you more if you showed us the relevant
parts of the code for your stored procedure VALIDATE_PIN.

Set