Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Assistance using pay_balance_view_pkg.get_balance_values — Cloud Customer Connect
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
37
Views
2
Comments
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,

    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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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