Search Results ns_hiring_date

Overview

APPS.PAY_KR_SEP_RESULT_TAX_V is a view in the Oracle E-Business Suite APPS schema that exposes the Korean severance pay (퇴직금) tax calculation results produced by the Oracle Payroll engine. It is registered under the FND Design Data object PAY.PAY_KR_SEP_RESULT_TAX_V with a status of VALID and is classified as an Internal view type. Oracle Corporation explicitly restricts direct access: the object is documented "Oracle Internal Use Only" and is not supported for direct customer querying except when invoked through standard Oracle Applications programs.

Functionally, the view presents the intermediate and final tax computation output for Korean severance payments. It surfaces values such as taxable earnings, income exemptions, YTD and current-year calculation bases, calculated tax, tax breaks, actual tax, and the disaggregated income, resident, and special tax components (ITAX, RTAX, STAX). Both the current-period ("WKPD", "NS_" prefixed) and prior-period ("PREV_", "NS_PREV_") severance figures are provided in parallel column sets, which allows a payroll run to reflect retroactive recalculation without losing the historical baseline.

Underlying Base Objects

The view is defined over the following documented base objects:

• PAY_ASSIGNMENT_ACTIONS (SYNONYM) — supplies the ASSIGNMENT_ACTION_ID and ASSIGNMENT_ID context linking the computed result to the specific payroll action instance.
• PAY_ACTION_INTERLOCKS (SYNONYM) — provides payroll action and run context for the calculation.
• PAY_PAYROLL_ACTIONS (SYNONYM) — identifies the payroll action under which the severance run was processed.
• PAY_RUN_TYPES_F (SYNONYM) — resolves RUN_TYPE_ID and controls which severance tax rules apply.
• HR_GENERAL (PACKAGE) — used for date and period derivation, particularly for working-period and service-period calculations.
• PAY_KR_REPORT_PKG (PACKAGE) — the Korean payroll reporting package that encapsulates the country-specific severance tax formulas and populates the result strings.

Most numeric result columns are exposed as VARCHAR2(4000) rather than native NUMBER, reflecting the internal Oracle Payroll practice of carrying calculated magnitude values as character strings with associated number-of-digits metadata.

Key Columns

• ASSIGNMENT_ACTION_ID / ASSIGNMENT_ID — Primary linkage to the payroll action and the assignment being processed.
• EFFECTIVE_DATE / DATE_EARNED — When the severance calculation is effective and when the earnings were deemed earned.
• HIRING_DATE / LEAVING_DATE — The assignment's current hire and termination dates.
• WORKING_PERIOD / SERVICE_PERIOD — The computed continuous service period underpinning severance entitlement.
• PREV_LAST_LEAVING_DATE — The prior severance event's last leaving date, used to determine overlap between a previous termination and the current one. Documented along with related overlap columns OVERLAP_WKPD and NS_OVERLAP_WKPD.
• WKPD_SEP_TAX / PREV_WKPD_SEP_TAX / NS_WKPD_SEP_TAX — Working-period severance tax values for current, prior, and non-standard (retro) computations.
• TOTAL_TAXABLE_EARNINGS / TAXABLE_EARNINGS_WI_PREV / INCOME_EXEM / TAXATION_BASE — The tax base build-up from total taxable earnings through income exemption to the final taxation base.
• CALC_TAX / ACTUAL_TAX / YCALC_TAX / YTAXATION_BASE — Calculated, actual, year-to-date calculated tax, and YTD taxation base.
• ITAX / RTAX / STAX and their GROSS_ equivalents — Income, resident, and special tax components, gross and net.
• NS_* columns — A parallel non-standard/retroactive result set mirroring the primary severance computation.

Common Use Cases and Queries

Because the object is marked internal, it should be accessed through supported Korean severance reports and payroll processes rather than directly. Where read-only diagnostics are permitted, the view is typically joined to PAY_ASSIGNMENT_ACTIONS on ASSIGNMENT_ACTION_ID to review the tax build-up for a given assignment action.

A representative diagnostic query:

• SELECT aa.assignment_action_id, aa.assignment_id, k.EFFECTIVE_DATE, k.LEAVING_DATE, k.PREV_LAST_LEAVING_DATE, k.SERVICE_PERIOD, k.TAXATION_BASE, k.CALC_TAX, k.ACTUAL_TAX FROM APPS.PAY_KR_SEP_RESULT_TAX_V k, APPS.PAY_ASSIGNMENT_ACTIONS aa WHERE k.assignment_action_id = aa.assignment_action_id AND aa.assignment_id = :p_assignment_id ORDER BY k.effective_date DESC;

Typical scenarios include reconciling severance tax against the processed payroll run, auditing the effect of a prior termination date (via PREV_LAST_LEAVING_DATE) on the current service period and overlap, and verifying that the NS_ (retroactive) columns correctly track the revised calculation alongside the original figures.