SQL for Current approver of AP Invoice

Summary:

We have requirement to find the current approver of AP Invoice if the invoice is under approval .

We are using below query to find the current approver

select APPROVER_ID from ap_inv_aprvl_hist_all where history_type = 'DOCUMENTAPPROVAL' and action_date is null

order by invoice_id , approval_history_id

Please let us know if it is right way to identify the current approver of Invoice approval.

Content (required):

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

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