Need help in Fetching Arrear Balance Value with pay_balance_view_pkg.get_balance_values

Hello

Hope everyone is doing well!

I need to use the below query to fetch Inception to Date Arrear Balance for Benefits Deductions in a existing BI query, the below query is running forever and getting time out. Also if i run with 'Blue Option High Option Pretax' and '_REL_YRD', we are getting correct results.

Any help/pointers would be highly appreciated.

select
bal.balance_value
from
fusion.pay_payroll_actions ppa
,fusion.pay_pay_relationships_dn pprd
,fusion.pay_payroll_rel_actions pra
,fusion.pay_action_classes pac
,table(pay_balance_view_pkg.get_balance_values
(p_payroll_rel_action_id => pra.payroll_rel_action_id