Logic to find the Next Approver Name for the resignation process

KeerthanaBaskaran

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.

KeerthanaBaskaran

Please anybody suggest on how to achieve the above case. Thanks, in advance.