How to fetch max row of any specific action using object function

Summary:

Customer want to put validation of Secondment action, for that purpose I want to fetch max row of Secondment Begin from rowset

I am currently trying to loop using nested for loop which is working but not for all the scenarios.

Content (please ensure you mask any confidential information):

How to fetch max row of any specific action using object function, Customer want to put validation of Secondment action, for that purpose I want to fetch max row of Secondment Begin from rowset

I am currently trying to loop using nested for loop which is working but not for all the scenarios.