Search Results csr_a

Overview

APPS.PAY_KR_YEA_MAGTAPE_PKG is a Korean localization payroll package within Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to generate the Year-End Adjustment (YEA) magnetic tape and related statutory reports required by the Korean National Tax Service for annual employee income tax settlement. The package queries HR and Oracle Payroll organization structures together with Korean business place registration information to assemble the data set that must be reported to tax authorities.

The package body carries header version pykryeam.pkb 120.2.12010000.1. The presence of multiple bug-fix references in the source indicates the package has been iteratively maintained to align with evolving Korean statutory formats.

Key Procedures and Functions

ETRM documents one public procedure or function for this package:

• GET_TAX_REDUCTION_DATE — Returns the tax reduction date applicable to a given employee record for year-end adjustment reporting. This date governs eligibility windows for Korean income tax deductions and is consumed when populating the YEA magtape output.

The package body also contains an internal (non-public) procedure named populate_a, used to build result sets for report variant 'A'. It retrieves business place registration attributes from HR_ORGANIZATION_INFORMATION.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• HR_ORGANIZATION_INFORMATION — Korean business place registration and income tax attributes.
• HR_ORGANIZATION_UNITS_TL and PER_ORG_STRUCTURE_ELEMENTS — Organizational hierarchy for business place selection.
• HR_LOCATIONS_ALL and PER_ADDRESSES — Address data for the reporting entity and employees.
• PER_PERIODS_OF_SERVICE and PAY_ASSIGNMENT_ACTIONS — Employment and assignment history.
• PAY_PAYROLL_ACTIONS — Payroll run context.
• PER_ASSIGNMENT_EXTRA_INFO and PER_CONTACT_EXTRA_INFO_F — Additional reporting attributes.
• FND_TERRITORIES — Territory reference data.
• FF_USER_ENTITIES — FastFormula user entity definitions.

Usage Notes

The package is invoked from the Korean year-end adjustment concurrent program and is referenced by one other package. It is not intended for standalone or ad hoc execution; it is called from the seeded YEA magtape generation flow. Modifications require validation against the Korean National Tax Service format specification.