We have a requirement to build a resignation report, in that we need fetch the Current approver and Next approver. We are able to get the Current approver from the table 'fa_fusion_soainfra.WFTASK' and column 'assigneesdisplayname'.
But we are not able to fetch the Next approver if the resignation process approval is pending with Current approver.
Kindly suggest a solution.
