Search Results prev_eligible_for_ptax

Overview

APPS.PAY_KR_SEP_TAX_WO_ADDR_V is a reporting view in the Oracle E-Business Suite Payroll module, owned by the APPS schema and registered under FND Design Data as PAY.PAY_KR_SEP_TAX_WO_ADDR_V. Its name indicates that it supports the Korean severance (separation) tax reporting process — specifically the "without address" variant, implying it is intended for layouts or submissions where the employee's residential address is not required, while corporate and tax-office information is retained. The view consolidates payroll action, assignment action, element entry, person, and organization data into a single denormalized row per severance payment, exposing fields such as CORP_NAME, CORP_REPRESENTATIVE_NAME, CORP_NUMBER, BP_ADDRESS, TAX_OFFICE_NAME, BP_NUMBER, and the various PREV_* (prior-period) severance amounts. Because it is marked "Oracle Internal Use Only," it must not be queried directly by customer code; it is consumed exclusively by Oracle-delivered concurrent programs and report packages, principally PAY_KR_SEP_FORM_PKG and PAY_KR_REPORT_PKG, which render the Korean severance tax forms. Users searching for "corp_name" are typically looking for the legal corporate name of the employer or business place to appear on a severance tax filing or withholding statement.

Underlying Base Objects

The view is defined over a blend of payroll, human resources, and FND objects. Transactional payroll data is drawn from the PAY_* synonyms: PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INTERLOCKS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_LINK_INPUT_VALUES_F, and PAY_RUN_TYPES_F. Person and assignment context comes from PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_PERIODS_OF_SERVICE, and the HR_PERSON_NAME package, while organization and location attributes (business place number, corporate name, representative name, address, tax office) are resolved through HR_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS, and FND_TERRITORIES_VL. Security and territory handling use HR_SECURITY, HR_GENERAL, and FND_TERRITORIES_VL. The two Korean localization packages, PAY_KR_SEP_FORM_PKG and PAY_KR_REPORT_PKG, supply the derivation logic for the severance and tax columns, including the PREV_* prior-employment fields used to aggregate service periods for severance calculation.

Key Columns

• CORP_NAME (VARCHAR2 150): The legal corporate name of the employing organization or business place, sourced from organization information and printed on the severance tax form.
• CORP_REPRESENTATIVE_NAME (VARCHAR2 150): The name of the corporate representative signing the filing.
• CORP_NUMBER (VARCHAR2 150): The corporate registration number for the business place.
• BP_NUMBER / BP_ADDRESS / TAX_OFFICE_NAME: Business place identifier, address, and the competent tax office, all used for jurisdictional routing of the withholding.
• ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, PAYROLL_ACTION_ID, PAYROLL_ID, BUSINESS_GROUP_ID: Payroll run and assignment action keys that isolate a specific severance payment record.
• EFFECTIVE_DATE / XEFFECTIVE_DATE / DATE_EARNED: Effective and earned dates governing the reporting period.
• NATIONAL_IDENTIFIER, LAST_NAME, FIRST_NAME, NATIONALITY, PERSON_ID: Employee identity attributes for the taxpayer.
• HIRING_DATE, LEAVING_DATE, PREV_FIRST_HIRING_DATE, PREV_LAST_LEAVING_DATE, ACTUAL_TERMINATION_DATE: Service period data, including prior employment, used to compute severance entitlement.
• PREV_ELIGIBLE_FOR_PTAX, PREV_SP_NON_TAX_AMT, PREV_SEP_PAY, PREV_SEP_INS: Prior-period severance and tax-eligibility amounts carried forward for cumulative taxation.
• SEP_PAY_OVERSEAS_TAX_BREAK, STAT_SEP_PAY_POST_TAX_DEDUC, NON_STAT_SEP_POST_TAX_DEDUC: Statutory and non-statutory severance tax and post-tax deduction amounts.

Common Use Cases and Queries

This view is designed to feed the Korean severance tax report and its address-suppressed form. A support analyst might inspect a specific payroll action to confirm which corporate name and business place were reported, joining on the payroll action identifiers. For example:

• Select a temporary employee's identity: SELECT TEMP_EMP_ID, CORP_NAME, HIREDATE, SALARY, TAX, FLSA_STATUS, EXPATRIATE, PAYROLL_NAME, LAST_NAME, FIRST_NAME FROM XX_CORP_EMPLOYEES.

While that example queries a customer view, the same reporting pattern applies to PAY_KR_SEP_TAX_WO_ADDR_V: filter by BUSINESS_GROUP_ID, PAYROLL_ID, and PAYROLL_ACTION_ID to isolate a run, then select CORP_NAME, CORP_REPRESENTATIVE_NAME, BP_NUMBER, TAX_OFFICE_NAME, and the person and severance amount columns. In practice, direct access is unsupported; production use is through the seeded Korean severance concurrent programs and PAY_KR_SEP_FORM_PKG. Any diagnostic query should therefore be executed only in non-production environments with explicit Oracle support guidance, and results should not be used to drive downstream integrations.