You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Assistance using pay_balance_view_pkg.get_balance_values

Accepted answer
edited Aug 25, 2023 12:12PM in Payroll and Global Payroll Interface (GPI) 2 comments

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,





from fusion.pay_payroll_actions ppa

  ,fusion.pay_pay_relationships_dn pprd

  ,fusion.pay_payroll_rel_actions pra

  ,fusion.pay_action_classes pac


     (p_payroll_rel_action_id   => pra.payroll_rel_action_id


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!