I want the list of approvers and the limit on the amount each approver can approve.
I want the table that stores the approver name/ID and the limit on amount which they can approver.
E.g. When an expense report is submitted there are few approvers who can only approve the amount less than 10000 and few who can approve above 10000.
I want to build a query which gives details on who are the approvers for a particular transaction and what is the amount limit they can approve.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):