Search Results ca_soe_short_name




Overview
Explore in AI Chat

Overview

APPS.PAY_CA_SOE_DEDN_BALANCES_V is a Canadian payroll reporting view used by the Statement of Earnings (SOE) and related statutory reporting processes in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes deduction and balance information for a payroll assignment in a form suitable for the Canadian SOE layout. The view resolves the actual balance value at runtime rather than storing it, invoking the payroll balance API for each row according to the payroll action type. This makes the view a thin, calculation-driven layer rather than a materialized reporting table.

The view is relevant to users searching for the term run_value, which corresponds to the runtime context used by the balance resolution calls. The view derives reported balances for run-type actions and, where applicable, current or on-demand values.

Underlying Base Objects

The documented base objects include:

The view is therefore a consolidated projection over payroll assignment, action, element and balance metadata, with the actual amounts computed by PL/SQL packages at query time.

Key Columns

  • assignment_id — the payroll assignment being reported.
  • assignment_action_id — the specific assignment action (run, quickpay, reversal, etc.) providing context for balance calculation.
  • tax_unit_id — the tax unit associated with the assignment action.
  • element_type_id, element_name — identification of the payroll element.
  • classification_id, classification_name — element classification for grouping and SOE placement.
  • reporting_name — the element's reporting label, optionally substituted by the CA_SOE_SHORT_NAME lookup value.
  • processing_priority — controls ordering of elements in SOE output.
  • Decoded balance value — derived via pay_ca_balance_pkg.call_ca_balance_get_value, with the context argument set to 'RUN' for run-type actions and 'CURRENT' for other action types, producing the reported deduction balance.

Common Use Cases and Queries

Typical uses include generating Canadian Statement of Earnings deduction sections, reconciling run results to reported balances, and troubleshooting run_value discrepancies. Because values are computed for a given assignment action, queries must be scoped to a valid assignment_action_id.

SELECT assignment_id,
       assignment_action_id,
       element_name,
       reporting_name,
       classification_name
FROM   apps.pay_ca_soe_dedn_balances_v
WHERE  assignment_action_id = :p_assignment_action_id
ORDER  BY processing_priority;

To compare a run against a current value, join the view to PAY_PAYROLL_ACTIONS and filter on action_type. Performance is optimized for nested-loop access against the payroll indexes referenced by the view hints, so restricting by assignment_action_id or tax_unit_id is strongly recommended. Because the amount columns invoke PL/SQL for each row, large unfiltered extracts should be avoided in favour of targeted reporting queries.