Search Results get_balance_type_id

Overview

APPS.PAY_KR_SEP_PKG is a Korean localization payroll package within the Oracle E-Business Suite Payroll (PAY) module. The "SEP" designator is associated with the Korean separation and severance-related processing performed by Korean payroll customers. At the package-body level, PAY_KR_SEP_PKG performs the balance-type and user-entity resolution work that supports Korean statutory calculations — notably income tax (itax), resident tax (rtax), special tax (stax), and health insurance premiums (hi_prem) for both employee and employer, each tracked in regular and "without adjustment" (wo_adj) forms.

The package declares a set of global package-level variables that cache the identifiers resolved at runtime, including business group, legislation code, and the balance type and user entity identifiers for each tax and premium element. This caching model is characteristic of Korean localization code, where the same balance lookups are repeated across many adjustment routines within a payroll run.

Key Procedures and Functions

• GET_BALANCE_TYPE_ID — Resolves the BALTANCE_TYPE_ID for a supplied balance name, restricted to a business group and legislation. It opens an explicit cursor over PAY_BALANCE_TYPES matching the balance name, with NVL-based defaults that fall back to the cached g_business_group_id and g_legislation_code when the row's own columns are null. If the incoming business group differs from the cached value, the procedure refreshes g_business_group_id and derives g_legislation_code via PAY_KR_REPORT_PKG.LEGISLATION_CODE. The output parameter is populated only when currently null, so repeated calls behave idempotently.
• GET_USER_ENTITY_ID — Resolves the user entity identifier for a supplied user entity name, following the same caching pattern for the g_*_ue_id global variables that correspond to the tax and premium elements.
• GET_IYEA_TAX_ADJ — Documented procedure associated with the income tax adjustment logic for the Korean localization.
• GET_IHIA_PREM_ADJ — Documented procedure associated with the health insurance premium adjustment logic.

The package also maintains helper logic for tax and premium adjustment totals; parameter signatures beyond the documented cursor-driven resolution pattern should be confirmed against the deployed source in each environment.

Tables Accessed

• PAY_BALANCE_TYPES — The primary reference table. GET_BALANCE_TYPE_ID queries BALANCE_NAME, BUSINESS_GROUP_ID, and LEGISLATION_CODE to return the corresponding BALANCE_TYPE_ID, which downstream Korean tax calculations use to store and retrieve balances.
• FF_USER_ENTITIES — The Oracle FastFormula user-entity definition table, queried by GET_USER_ENTITY_ID to map a user entity name to its USER_ENTITY_ID for use in FastFormula and balance feeds.

Usage Notes

PAY_KR_SEP_PKG is invoked from within Korean localization payroll processing rather than directly by end users. It is called by the Korean balance-loading and adjustment routines, by FastFormula-driven payroll runs operating under the KR legislation, and by any custom Korean payroll code that needs the numeric identifiers behind balance names and user entity names. The ETRM metadata records no packages referencing PAY_KR_SEP_PKG, indicating it sits at the top of the dependency chain within its localization layer.

Because the procedure caches business group and legislation in package globals, callers should invoke it once per business group session and reuse the returned identifiers. In EBS 12.1.1 and 12.2.2, the package is deployed under the APPS schema; the package body carries a header revision dated December 2002, confirming its long-standing role in Korean payroll. The NOCOPY hint on the IN OUT parameter reduces copying overhead for the frequently repeated balance lookups.