Need to retrieve begin balance of user from anc_per_accrual_entries Table through Value set in FF

Summary:

When Assignment change happens on 1/1/YYYY, user is getting both Reinstated balance and Accrual for a frontloaded plan which is wrong. They need to only get Accrual and we can't disable reinstated balance from plan configuration as it effects other cases. So we've to fetch Reinstated balance which is Begin balance in anc_per_accrual_entries Table and adjust the values in FF.

ISSUE : SQL Query from backend is working but when calling in FF through Value set it's not retrieving any data.

SQL QUERY:

select a.begin_bal

from anc_per_plan_enrollment appe, anc_absence_plans_f_tl tl, anc_per_accrual_entries a