How to added a approve rul to the invoice be informed that prepayment exist?

Summary:

Customer wants to add a rule to route an additional approval when the invoice being approved belongs to a supplier that has an open prepayment.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications24A

Code Snippet (add any code snippets that support your topic, if applicable):