Results for “balance_type_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.HR_JP_ID_PKG is a Japanese localization package body within the Oracle E-Business Suite Human Resources and Payroll schema. It functions as a consolidated data-access and caching layer that resolves the primary and foreign key identifiers required by Japanese payroll and HR processing logic. Rather than embedding repeated lookups against flexfield, element, balance, backpay, and organization tables into every calling module, the package centralizes these retrievals and exposes them through typed record structures and narrow ID-returning functions.
The package is classified by ETRM as an OTHER API, indicating it is a supporting utility package rather than a formal public HR API. Its status is VALID in release 12.1.1 and 12.2.2, and it references 23 other packages while not itself being referenced by any database object, which places it at the leaf end of the dependency chain. Its defined procedures and functions number 111 in the documented metadata.
Key Procedures and Functions
The documented entry points fall into recognizable functional clusters, each pairing a record-returning routine with an ID-returning counterpart:
- LATEST_SQL — captures the most recently executed SQL statement text, used for diagnostics and error reporting within the package.
- KEYFLEX_COMBINATION_ID — resolves a key flexfield combination identifier for a supplied flexfield context.
- BUSINESS_GROUP_REC — returns the business group context used to scope subsequent legislative lookups.
- LEGISLATION_CODE and ID_FLEX_NUM — identify the Japanese legislation and the applicable key flexfield structure.
- DEFAULT_CURRENCY_CODE — returns the default currency for the operating context.
- ELEMENT_SET_REC / ELEMENT_SET_ID — retrieve payroll element set definitions and their identifiers.
- BACKPAY_SET_REC / BACKPAY_SET_ID — retrieve backpay set definitions and identifiers.
- CLASSIFICATION_REC / CLASSIFICATION_ID — return element classification details and keys.
- ELEMENT_TYPE_REC / ELEMENT_TYPE_ID — resolve element type records and identifiers.
- BALANCE_TYPE_REC / BALANCE_TYPE_ID — return balance type definitions and identifiers.
- BALANCE_DIMENSION_REC / BALANCE_DIMENSION_ID — return balance dimension definitions and identifiers.
- ASSIGNMENT_STATUS_TYPE_REC / ASSIGNMENT_STATUS_TYPE_ID — return assignment status type records and their identifiers.
Tables Accessed
The package reads from several families of application tables via APPS synonyms. Payroll configuration data is drawn from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_SETS, PAY_ELEMENT_CLASSIFICATIONS, PAY_INPUT_VALUES_F, PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_FEEDS_F, PAY_DEFINED_BALANCES, PAY_BACKPAY_SETS and PAY_BACKPAY_RULES, PAY_GRADE_RULES_F, PAY_FORMULA_RESULT_RULES_F, PAY_SUB_CLASSIFICATION_RULES_F, PAY_STATUS_PROCESSING_RULES_F, PAY_CONSOLIDATION_SETS, PAY_RATES, and related payroll and payment-method tables.
Flexfield resolution depends on FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, FND_FLEX_KEYVAL, FND_CURRENCIES, FF_FORMULAS_F, FF_FORMULA_TYPES, and FF_FUNCTIONS. Human resources data is sourced from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_BUSINESS_GROUPS, PER_GRADES, PER_JOBS, PER_POSITIONS, PER_PAY_BASES, PER_PERSON_TYPES, PER_ASSIGNMENT_STATUS_TYPES, PER_ADDRESSES, HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, and HR_ASSIGNMENT_SETS. Japanese-specific bank data is read from PER_JP_BANK_LOOKUPS. These tables supply the values the package caches and returns as IDs and record structures.
Usage Notes
HR_JP_ID_PKG is an internal supporting package. It is typically invoked indirectly by Japanese payroll and HR forms, concurrent programs, and localization routines that require resolved identifiers for element types, balance types, dimensions, backpay sets, classifications, and assignment status types without reissuing the underlying queries. Custom extensions that mirror Japanese payroll configuration should call the documented ID and record functions rather than querying the base tables directly, preserving consistency with standard localization behavior.
-
PACKAGE: APPS.HR_JP_ID_PKG 12.1.1
-
PACKAGE: APPS.HR_JP_ID_PKG 12.2.2
-
Table holds balance types for specific assignments
-
This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process.
-
View: PAYLV_BALANCE_TYPE_V 12.2.2
APPS.PAYLV_BALANCE_TYPE_V·↳ HR_BIS·↳ PAY_BALANCE_TYPES·↳ PAY_BALANCE_TYPES_TL·Explore PAY module →
-
APPS.PAY_GB_PAYSLIP_BALANCE_TYPES_V·↳ PAY_BALANCE_TYPES·Explore PAY module →
-
This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process.
-
View: PAY_CA_SUPP_EARNINGS_V 12.1.1
APPS.PAY_CA_SUPP_EARNINGS_V·↳ PAY_BALANCE_TYPES·↳ PAY_BALANCE_TYPES_TL·↳ PAY_ELEMENT_CLASSIFICATIONS·Explore PAY module →
-
New Zealand localisation view.
APPS.PAY_NZ_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
Australian localisation view.
APPS.PAY_AU_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
APPS.PAY_CA_RB_SUPP_EARNINGS_V·↳ PAY_BALANCE_ATTRIBUTES·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_TYPES·Explore PAY module →
-
APPS.PAY_GB_BALANCES_BY_ACTION_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
New Zealand localisation view.
APPS.PAY_NZ_BALANCES_BY_ACTION_V·↳ HR_NZBAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
New Zealand localisation view.
APPS.PAY_NZ_BALANCES_BY_ACTION_V·↳ HR_NZBAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
APPS.PAY_GB_BALANCES_BY_DATE_V2·↳ FND_SESSIONS·↳ HR_GBBAL·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
Table holds codes for IRP5 balances
-
APPS.PAYBV_US_TAX_BALANCES_V·↳ HR_BIS·↳ PAY_US_TAX_BALANCES·Explore PAY module →
-
Singapore localisation view.
APPS.PAY_SG_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
APPS.PAY_GB_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
Singapore localisation view.
APPS.PAY_SG_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_PAYJPDMW_VALUES_V·↳ FF_CONTEXTS·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
PAY_ZA_BALANCES_BY_PERIOD_V gives you a list of balances per assignment and time period.f
APPS.PAY_ZA_BALANCES_BY_PERIOD_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
APPS.PER_BF_BALANCE_ELEMENTS_V·↳ PAY_ELEMENT_TYPES_F·↳ PAY_INPUT_VALUES_F·↳ PER_BF_BALANCE_TYPES·Explore PER module →
-
New Zealand localisation view.
APPS.PAY_NZ_BALANCES_BY_DATE_V2·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_NZBAL·Explore PAY module →
-
APPS.HRBV_BACKFEED_BALANCE_ELEMENTS·↳ PAY_ELEMENT_TYPES_F·↳ PAY_INPUT_VALUES_F·↳ PER_BF_BALANCE_TYPES·Explore PER module →
-
Australian localisation view.
APPS.PAY_AU_BALANCES_BY_DATE_V2·↳ FND_SESSIONS·↳ HR_AUBAL·↳ HR_GENERAL·Explore PAY module →
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_BALANCES_BY_DATE_V2·↳ FND_SESSIONS·↳ HR_JPBAL·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
Table holds codes for IRP5 balances
-
View: PAY_DEFINED_BALANCES_V 12.1.1
Used to support user interface
APPS.PAY_DEFINED_BALANCES_V·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_DEFINED_BALANCES·Explore PAY module →
-
Holds details about defined balances that are marked to store run balances
APPS.PAY_RUN_BALANCE_STATUS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
Table holds balance types for specific assignments
-
View: PAY_JP_BALANCES_V 12.1.1
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_BALANCES_V·↳ FF_DATABASE_ITEMS·↳ FF_USER_ENTITIES·↳ HR_JPBAL·Explore PAY module →
-
APPS.PAY_GROSSUP_BAL_EXCL_V3·↳ FND_SESSIONS·↳ PAY_BALANCE_TYPES·↳ PAY_BALANCE_TYPES_TL·Explore PAY module →
-
View: PAY_PAYNZBAL_VALUES_V 12.2.2
New Zealand localisation view.
APPS.PAY_PAYNZBAL_VALUES_V·↳ HR_NZBAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·Explore PAY module →
-
PAY_ZA_BALANCES_BY_DATE_V gives you a list of balances per assignment and effective date.
APPS.PAY_ZA_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
View: PAY_PAYGBBAL_VALUES_V 12.2.2
APPS.PAY_PAYGBBAL_VALUES_V·↳ FF_CONTEXTS·↳ FF_ROUTE_CONTEXT_USAGES·↳ HR_GBBAL·Explore PAY module →
-
PAY_ZA_BALANCES_BY_PERIOD2_V gives you a list of balances per assignment and time period.
APPS.PAY_ZA_BALANCES_BY_PERIOD2_V·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_TYPES·↳ PAY_DEFINED_BALANCES·Explore PAY module →
-
Element Template Grossup Balance Exclusions
-
PAY_ZA_BALANCES_MATRIX_V gives you a list of balance dimensions for the appropriate balance per assignment and assignment action ID in a matrix format.
APPS.PAY_ZA_BALANCES_MATRIX_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·↳ PAY_BALANCE_TYPES·Explore PAY module →
-
APPS.PER_BF_BALANCE_ELEMENTS_V·↳ PAY_ELEMENT_TYPES_F·↳ PAY_INPUT_VALUES_F·↳ PER_BF_BALANCE_TYPES·Explore PER module →
-
Used to support user interface
APPS.PAY_DEFINED_BALANCES_LOV·↳ FF_CONTEXTS·↳ FF_ROUTE_CONTEXT_USAGES·↳ HR_API·Explore PAY module →
-
APPS.PAY_GB_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
New Zealand localisation view.
APPS.PAY_NZ_BALANCES_BY_DATE_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PAY module →
-
- Retrofitted
APPS.PAY_BALANCE_DEFINED_DIMENSIONS·↳ PAY_ASSIGNMENT_LATEST_BALANCES·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_TYPES·Explore PAY module →