Search Results prev_bp_name




Overview
Explore in AI Chat

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

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:

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.