Inactive Employee Expense Approval

Summary:

We have employee expenses set up with supervisor approval. Where we have an expense claim submitted by the delegate of an inactive employee, the rule finds no approver due to the inactive employee having no line manager.

We would like to set up a rule so that it looks at the inactive employees' previous assignment to derive the approver - any advice on how we would do this please?