How to get Payroll Balance value in the Benefits Fast Formula

Summary:

How to get Payroll Balance value in the Benefits Fast Formula

Content (please ensure you mask any confidential information):

I am writing the Rate Value Calculation Fast Formula, it will be attached at Benefits Rate configuration. In that I need to get the Payroll Balance deduction happened for that employee. I need to get the YTD balance value for the calculation. How can I get it. I have Payroll balance query but its a big one, the valueset will not be enough to hold the query. I am using pay_balance_pkg.get_value_dbi() function to get the balance value. I tried to put subquery inside the Where clause but its not possible. Is there any better way to get it? I