For more information, please refer to this announcement explaining best practices for getting answers to questions.
Assistance using pay_balance_view_pkg.get_balance_values
Summary: I am trying to get a balance for SUI Employer Reduced Subject Withholdable using the below query. I have attached an image showing that there are values for this balance, but I must not have the right name or suffix for it. Can anyone point me in the right direction?
select pprd.payroll_relationship_number,
ppa.effective_date,
bal.BALANCE_NAME,
bal.Description,
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