Business Requirement to limit Cash Advance for each per employee

Hi Oracle Community,

Please I have a critical requirement from Petty Cash Department that they must have a solution to limit Cash Advance Amount for each per employee (Petty Cashier).
Let's say that we have two petty cashiers
First Petty Cashier : has limit to get cash advance amount of 10,000
Second Petty Cashier: has limit to get cash advance amount of 25,000

So we need the system if the first one submitted cash advances and he reached on one of them more than the his available amount (10,000) system stops him from submission.

Please does any one has a Solution\workaround for our case?