Requisition approvals using SQL Query to route to different approvers

We have a requirement concerning requisition approvals that need to follow a specific workflow based on the department's cost center hierarchy and the requester's job level. The approval process should work as follows:
1 Initial Routing: Requisition approvals should first route to the FP&A approver (i.e., the department cost center manager), based on the department to which the requester is tagged.
2 Hierarchy-based Routing: Following this, the approval should then follow the requester's job level hierarchy.
3 Post Hierarchy Routing: If the requisition amount exceeds $100K, the approval should route to the manager of the cost center.
To meet this requirement, we proposed to the client that they map cost center managers to the relevant cost centers within the respective departments in " Manage Department" task, so that requisitions are routed to the correct manager. However, this mapping process introduces a significant burden, as any changes, such as employees leaving or new departments/cost centers being added, would require manual updates to the mappings.