How to get the the latest balance from HCM Extract

Hi,

I have created a balance group HCM extract to retrieve the custom balance value.

I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type as Balance group.

I am able to get the balance value but I can see multiple balance values that are processed in multiple payrolls.

I want to see only the most recent balance value generated in the most recent payroll run.

I tried to add filter in the data group, but not working as expected.

This the UE query:

SELECT pra.action_sequence , ppa.action_type , prt.base_run_type_name , ppa.effective_date , pra.payroll_relationship_id ,