Need to fetch approval details from transaction console in BIP Report

Summary:

We have a requirement to fetch the approver details to whom the transaction was assigned to each level of approver and also the next level approver details for the leave applied.

Content (please ensure you mask any confidential information):

Transaction has multiple levels of approval, 
we are only able to retrieve information about past and current approvers from the workflow and BPM tables history tables. 
However, we are unable to obtain details about future approvers.

Ask: Is there any way to get the approver details for each level and the future approvers details for a particular transaction?

Example - A transaction has 4 Level of approvers