Results for “pay_jp_payjpbal_values_v”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_JP_PAYJPBAL_VALUES_V is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product. It is documented as a balance view and is used exclusively for the Japanese localization. Its purpose is to expose payroll balance values at the assignment action level, resolving defined balances into their numeric values alongside identifying metadata such as balance type, defined balance, and the database item suffix that names the balance column.
The view presents two logical result sets, combined with a UNION ALL. The first branch returns balances for defined balances whose associated dimension is at assignment level or finer (excluding group-level dimensions) and whose period type is run-based (excluding payment period types). The second branch returns balances tied to a specific element entry source, computing the balance value with a source identifier and deriving an element name from the element entries and their translated element types. This makes the view useful for extracting both run-level aggregate balances and element-entry-specific balance values in a single, uniform structure.
Because it is a view rather than a table, it holds no data of its own; it is a query surface over the core payroll balance model.
Underlying Base Objects
The view selects from a set of payroll base tables and supporting objects referenced through APPS-owned synonyms and views. The documented referenced base objects are: FF_CONTEXTS, FND_NUMBER, PAY_ACTION_CONTEXTS, PAY_ASSIGNMENT_ACTIONS, PAY_BALANCE_DIMENSIONS_VL, PAY_BALANCE_FEEDS_F, PAY_BALANCE_PKG, PAY_DEFINED_BALANCES, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F_TL, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, and PAY_RUN_RESULTS.
Central to the definition is PAY_BALANCE_PKG, whose GET_VALUE function is invoked to compute each balance value from a defined balance identifier and assignment action. PAY_DEFINED_BALANCES supplies the balance and balance type identifiers. PAY_BALANCE_DIMENSIONS_VL provides dimension attributes including the database item suffix, dimension level, and period type, which drive the branch filters. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS anchor the action context and business group. The second branch additionally reads element entries and translated element types to derive the element name, and joins through PAY_ACTION_CONTEXTS, PAY_RUN_RESULTS, PAY_INPUT_VALUES_F, PAY_BALANCE_FEEDS_F, and FF_CONTEXTS to identify the element entry source.
Key Columns
- ASSIGNMENT_ACTION_ID — The assignment action under which the balance is evaluated; the primary driving key.
- BALANCE_TYPE_ID — Identifier of the balance type to which the defined balance belongs.
- DEFINED_BALANCE_ID — Identifier of the defined balance being retrieved.
- DATABASE_ITEM_SUFFIX — Suffix applied to the database item name for the balance, taken from the balance dimension.
- VALUE — The numeric balance value returned by PAY_BALANCE_PKG.GET_VALUE; the core measurement.
- ELEMENT_NAME — For the element-entry branch, the minimum element name from translated element types; NULL in the first branch.
- SOURCE_ID — Identifier of the element entry source; NULL in the first branch.
- DISPLAY_ORDER — Literal value of 1 for the first branch and 0 for the second branch, controlling ordering.
Common Use Cases and Queries
Typical use is to extract computed balance values for Japanese payroll reporting, reconciliation, and downstream interfaces. The view is joined by assignment action and defined balance, and it is frequently filtered by balance type. A representative query is:
SELECT assignment_action_id, balance_type_id, defined_balance_id, database_item_suffix, value FROM apps.pay_jp_payjpbal_values_v WHERE assignment_action_id = :p_assignment_action_id ORDER BY display_order, database_item_suffix;
To isolate element-entry-level balances (the second branch), filter on a non-null source:
SELECT assignment_action_id, defined_balance_id, element_name, source_id, value FROM apps.pay_jp_payjpbal_values_v WHERE source_id IS NOT NULL AND assignment_action_id = :p_assignment_action_id;
Because the underlying definition calls the PAY_BALANCE_PKG.GET_VALUE function per row, queries should be constrained by assignment action or balance type to limit execution cost. Note that the view definition carries a PUSH_SUBQ hint within its inline element-entry subquery, steering the optimizer to evaluate that subquery early so its result set can be joined efficiently against the outer payroll action tables.
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_PAYJPBAL_VALUES_V·↳ FF_CONTEXTS·↳ FND_NUMBER·↳ PAY_ACTION_CONTEXTS·Explore PAY module →
-
This is a balance view. This view is used for Japanese localization only.
APPS.PAY_JP_PAYJPBAL_VALUES_V·↳ FF_CONTEXTS·↳ FND_NUMBER·↳ PAY_ACTION_CONTEXTS·Explore PAY module →
-
SYNONYM: APPS.FF_CONTEXTS 12.1.1
-
SYNONYM: APPS.FF_CONTEXTS 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
PACKAGE BODY: APPS.HR_JPBAL 12.2.2
-
PACKAGE BODY: APPS.HR_JPBAL 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.