What's new in Customer Journeys?

Connect and learn more!
ytd payroll balance values using pay_run_balances — 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

ytd payroll balance values using pay_run_balances

Question
55
Views
0
Comments

Summary:

How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT      distinct PBTV.BALANCE_NAME  BALANCE_NAME,

         PRB.BALANCE_VALUE  OC_YTD_BAL1,

         PER.PERSON_number    person_number,

PBTV.BALANCE_TYPE_ID

       FROM

         PAY_RUN_BALANCES PRB,

         PAY_DEFINED_BALANCES PDB,

         PAY_BALANCE_DIMENSIONS PBD,

         PAY_BALANCE_TYPES_VL PBTV,

         PAY_PAYROLL_ACTIONS PPA,

         PAY_PAYROLL_REL_ACTIONS PPRA,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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