Search Results taxation_base

Overview

The APPS.PAY_KR_SEP_RESULT_TAX_V view is a payroll reporting object within the Oracle E-Business Suite Payroll (PAY) module. It is owned by the APPS schema and carries a VALID status. Its documented purpose is to return the Result of Separation Pay Tax based on an assignment_action_id. In the context of Oracle EBS 12.1.1 and 12.2.2, this view functions as a denormalized, report-oriented projection of Korean (KR) separation pay tax data, exposing values that are otherwise scattered across payroll action, payroll relationship, and balance/result storage structures.

The view is specifically relevant to the Korean localization of Oracle Payroll, where separation pay (退職金) taxation follows statutory rules that depend on hiring date, leaving date, prior employment history, working period, and overlap working periods. The presence of the WKPD and WKPD_NON_STAT_SEP_PAY result identifiers confirms that the view surfaces values calculated by the Korean separation pay tax payroll processes. Because the view is keyed on assignment_action_id, it is intended for consumption after the relevant payroll run has been processed and results have been written to the database.

Underlying Base Objects

Per the documented ETRM metadata, PAY_KR_SEP_RESULT_TAX_V references the following base objects:

• PAY_ASSIGNMENT_ACTIONS (synonym) — supplies ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID, and RUN_TYPE_ID, and is the primary driver of the view.
• PAY_PAYROLL_ACTIONS (synonym) — provides EFFECTIVE_DATE and DATE_EARNED.
• PAY_RUN_TYPES_F (synonym) — the run type definition associated with the assignment action.
• PAY_ACTION_INTERLOCKS (synonym) — used to associate the action with its interlock status.
• PAY_KR_REPORT_PKG (package) — the core Korean report utility package that performs the value extraction.
• HR_GENERAL (package) — general HR utility package invoked in the broader view definition.

The essential mechanism is that the view does not join directly to balance or result tables. Instead, it repeatedly calls PL/SQL functions inside PAY_KR_REPORT_PKG, such as GET_RESULT_VALUE_DATE, GET_RESULT_VALUE_NUMBER, and GET_BALANCE_VALUE. Each call is passed the assignment_action_id, the business_group_id, and a result or balance name. This design centralizes the lookup logic and allows the view to expose derived Korean separation pay tax values without hard-coding joins to the underlying run result storage.

Key Columns

• ASSIGNMENT_ACTION_ID — the primary key and driving column; identifies the payroll assignment action whose results are reported.
• ASSIGNMENT_ID — the assignment (employee) to which the action belongs.
• EFFECTIVE_DATE and DATE_EARNED — the payroll action effective date and date earned.
• RUN_TYPE_ID — the run type under which the action was processed.
• HIRING_DATE, LEAVING_DATE, and WORKING_PERIOD — values sourced from the WKPD result group, representing the employee's hiring date, leaving date, and computed working period for separation pay purposes.
• WKPD_SEP_TAX — the separation pay tax balance value for the assignment run, retrieved via GET_BALANCE_VALUE.
• PREV_FIRST_HIRING_DATE and PREV_LAST_LEAVING_DATE — prior employment period dates used to aggregate service across employers for statutory taxation.
• NS_HIRING_DATE, NS_LEAVING_DATE, NS_PREV_FIRST_HIRING_DATE, and NS_PREV_LAST_LEAVING_DATE — equivalent date values from the WKPD_NON_STAT_SEP_PAY group, covering non-statutory separation pay.
• PREV_WKPD_SEP_TAX — the previously accumulated separation pay tax balance.
• OVERLAP_WKPD — the overlapping working period balance, used to avoid double-counting service periods.

Common Use Cases and Queries

This view is principally consumed by Korean separation pay tax reporting, statutory filings, and reconciliation routines. A typical query retrieves all columns for a given assignment action:

• SELECT * FROM APPS.PAY_KR_SEP_RESULT_TAX_V WHERE ASSIGNMENT_ACTION_ID = :p_assignment_action_id;
• Join to PAY_ASSIGNMENT_ACTIONS and PER_ALL_ASSIGNMENTS_F to obtain the person or payroll context for a run.
• Filter by RUN_TYPE_ID or by the effective date range to extract separation pay tax results for a reporting period.

Because the view relies on package function calls, performance is sensitive to the number of assignment actions scanned; filtering by ASSIGNMENT_ACTION_ID is strongly recommended. Users searching for ycalc_tax will generally find that this view is the presentation layer for the tax values produced by the Korean separation pay calculation, rather than the calculation logic itself.