Report to show which approver name an offer is sitting in

Summary

Report to show which approver name an offer is sitting in

Content

We have a sequence of up to 5+ approvers in our offer stage. Is there code/function I can use to help me identify which approver the offer is sitting in? For example, approver (sequence 1 has approved), approver 2 (sequence 2, offer sitting in his/her que is the name I want to pull), approver (sequence 3,4,5,etc will be pending status). The criterias are Submission Job offer ( offer approval decision/offer approver name/ offer approver sequence)