ytd payroll balance values using pay_run_balances

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,