Fetching Gross Pay YTD for a terminated employee in BI Report

Summary

Fetching Gross Pay YTD for a terminated employee

Content

Hi,

  I am able to fetch Gross Pay YTD till last payroll process date but not after that. I require to fetch Gross Pay YTD as of date. Can anyone suggest that how to fetch Gross Pay YTD for a terminated employee?

Select DISTINCT (CASE WHEN pbd.base_dimension_name    = 'Core Relationship Tax Unit Year to Date'

      THEN pay_balance_pkg.get_value_dbi(p_defined_balance_id    => pdb.defined_balance_id

            ,p_payroll_rel_action_id => ppra.payroll_rel_action_id

    ,p_payroll_term_id       => pac.payroll_term_id