What is the efficient way to get balance value in BIP report?
Summary:
Currenly we are using below subqueries to get the balance values for any payroll_rel_action_id. But our report has many columns to get the balance value and it is taking time to execute for all employees.
TABLE(pay_balance_view_pkg.get_balance_values( p_payroll_rel_action_id => per_dets.payroll_rel_action_id
, p_base_balance_name1 => 'IN_TAX_DEDUCTION'
, p_database_item_suffix1 => '_REL_TYTD'))BAL
Is there any other way to get the balance value ?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):