How to Query Leave Accrual Table for most recent accrual process date in PeopleSoft HCM?

I am trying to query the last accrual process row for terminated employee. When I try to use a subquery with an aggregate of MAX it still returns all the rows. If I run the same query with a subquery of MAX for an active employee I get the most recent accrual process row. There has to be an easy way to do this for a terminated employee. Can someone please help me with this?

Thank you!