AME with legacy Purchasing Account Approval Groups

Hi

using 12.2

I have a requirement to route requisition approvals to chains of approvers based on a number of inputs.

For one of those chains it's the Account segment.

I have it working using SQL to lookup the starting approver on the ValueSet - but - that is a lot of maintenance and updates.

Has anyone used the legacy "Approval Groups" and "Assign Approval Groups" for this type of assignment and then called them from AME?

e.g.

Using: LINE_ITEM_STARTING_POINT_PERSON_ID

And SQL:

select FFV.HIERARCHY_LEVEL

from po_req_distributions_all prd, po_requisition_lines_all prl, FND_FLEX_VALUES FFV