Search Results vol_deductions




Overview
Explore in AI Chat

Overview

The view APPS.PAY_KR_SEP_RESULT_NET_V is a Korean localization reporting object within Oracle E-Business Suite, delivered as part of the Payroll (PAY) product for the Korea (KR) legislation. Consistent with its suffix _NET_V, the view exposes net pay related results for a Separation (SEP) payroll process — most commonly the severance or retirement settlement run performed for terminated employees under Korean statutory requirements. It assembles per-assignment-action payroll results into a single horizontal row per process instance, converting values that are normally stored as payroll balances and database items into reported columns.

The view is primarily consumed by the Korean separation/severance reporting programs and concurrent report definitions that rely on PAY_KR_REPORT_PKG, the Korean payroll reporting package. Because net pay in EBS is not stored as a static column on a payroll run row, the view resolves it at query time through package calls. Its role is therefore a reporting and integration bridge: it presents the calculation outcome (net pay, earnings, statutory taxes, deductions and prior-period adjustments) in a form suitable for extract programs, statutory submission formats, and reconciliation reports. The specific search term net_pay maps directly to the net_pay column, which returns the NET_PAY balance for the assignment action within the run.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the view as being defined over the following objects, all referenced through APPS synonyms:

  • PAY_PAYROLL_ACTIONS — the parent payroll action (run) record, providing effective date, date earned and run type context.
  • PAY_ASSIGNMENT_ACTIONS — the per-assignment action row that identifies the individual employee's participation in the run.
  • PAY_RUN_TYPES_F — the run type definition used to filter and classify the action.
  • PAY_ACTION_INTERLOCKS — the locking relationship between assignment actions; the view uses this to exclude actions that are locked by, or are themselves locking, another action, thereby avoiding duplicate or superseded results.
  • PAY_KR_REPORT_PKG — the Korean reporting package supplying the balance and database-item values via GET_BALANCE_VALUE and GET_DBITEM_VALUE.

The join is between PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS on the payroll action, with a NOT EXISTS clause over the interlock chain (PAY_RUN_TYPES_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INTERLOCKS). This predicate removes assignment actions that participate in interlocked runs, ensuring only the authoritative, unlocked result set is returned for reporting.

Key Columns

  • assignment_action_id / assignment_id — identifiers for the specific payroll action and the employee assignment.
  • effective_date / date_earned — the payroll period dates carried from PAY_PAYROLL_ACTIONS.
  • run_type_id — the run type of the separation process.
  • total_taxable_earnings — TOTAL_TAXABLE_EARNINGS balance, the taxable earnings base.
  • itax / rtax / stax — income tax, resident tax and special (local) tax withheld, reported as of the run.
  • net_pay — the NET_PAY balance for the action, returned as of the run; the primary search-relevant column.
  • vol_deductions / invol_deductions — voluntary and involuntary deduction totals.
  • np_prem_fund_reimb — non-periodic premium fund reimbursement, returned inception-to-date.
  • last_iyea_itax_adj, last_iyea_rtax_adj, last_iyea_stax_adj — prior year-end income, resident and special tax adjustments derived from database items.
  • last_ihia_prem_ee_adj / last_ihia_prem_er_adj — last health insurance separation adjustment for employee and employer charge, year-to-date.

Common Use Cases and Queries

Typical usage includes severance settlement reporting, net pay reconciliation, and statutory tax extracts for terminated Korean employees.

  • Retrieve net pay for a specific assignment action.
  • Report all separation results for a payroll period or run type.
  • Reconcile taxable earnings against taxes and deductions.
SELECT assignment_action_id,
       assignment_id,
       effective_date,
       date_earned,
       net_pay,
       itax, rtax, stax
FROM   apps.pay_kr_sep_result_net_v
WHERE  assignment_action_id = :p_assignment_action_id;

SELECT assignment_id, date_earned, total_taxable_earnings, net_pay
FROM   apps.pay_kr_sep_result_net_v
WHERE  effective_date BETWEEN :p_start AND :p_end
ORDER  BY assignment_id, date_earned;

Because each row invokes PAY_KR_REPORT_PKG functions, queries should be restricted by date or action identifiers to limit processing cost on large separation volumes.