query to get YTD balances for SIT Withheld

Summary:

We are trying to get the Year to date value for SIT Withheld Balance in SQL.For SIT Withheld balances we are not able to get YTD value. We can see the Run dimension values in the Pay_Run_balances table but there are no records for YTD balance value.

Any suggestions.

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
papf.person_number,
pni.national_identifier_number,
prb.balance_value,
ppa.effective_date,
pbtv.balance_name,