Results for “yea_class_id”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_JP_SOE_RUN_YEA_V is a reporting view within the Oracle E-Business Suite Payroll module, specifically scoped to the Japanese localization of the Statement of Earnings (SOE) process. The view consolidates run result values associated with a designated Year-End Adjustment (YEA) class element, resolving the element identified through the HR_JP_PARAMETERS setup where the parameter name is YEA_CLASS_ID under the owner PAYJPSOE. In practice, the view presents, for each assignment action, the run result identifiers, input value identifiers, human-readable value names, display sequencing, and numeric result values for the YEA-class element processed during a payroll run.
Its principal role is to feed Japanese SOE reporting and downstream integration logic, allowing the payroll engine and reporting layers to retrieve structured results without directly navigating the complex hierarchy of payroll run results, input values, and translated element metadata. Because it joins translated input value names and element names, it delivers localized labels suitable for statutory and employee-facing output.
Underlying Base Objects
The view is defined over a set of documented base objects, all referenced through APPS-owned synonyms and views in EBS 12.1.1 and 12.2.2:
- PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — provide the payroll action and assignment action context, linked on
payroll_action_idandassignment_action_id. - PAY_RUN_RESULTS — supplies the run results for the assignment action, filtered where the element type matches the YEA class element and the status is processing or partially processed (
'P','PA'). - PAY_RUN_RESULT_VALUES — holds the actual numeric or text result values keyed by
run_result_idandinput_value_id. - PAY_INPUT_VALUES_F and PAY_INPUT_VALUES_F_TL — define input values and their translated names, with the UOM restricted to
'M'(money) and language matched to the session viauserenv('LANG'). - PAY_ELEMENT_TYPES_F_TL — provides translated element and reporting names for display.
- HR_JP_PARAMETERS — the driving configuration that supplies the
YEA_CLASS_IDparameter value used to resolve the element type. - HR_LOOKUPS — resolves the
NAME_TRANSLATIONSlookup for code'PAY VALUE', used in a DECODE to determine label behavior. - HR_API — documented as a referenced package supporting the underlying payroll processing logic.
Key Columns
- assignment_action_id — the assignment-level action identifier that ties results to a specific payroll run for an assignment.
- run_result_id — the unique identifier of the run result row for the YEA-class element.
- input_value_id — identifies the input value whose result is being reported.
- Value Name — a DECODE-driven label that returns the translated reporting or element name when the input value is the PAY VALUE definition, otherwise the input value's translated name.
- Display Sequence — the ordering indicator for the input value, nulled when the entry is the PAY VALUE definition.
- Result Value — the numeric run result value, defaulted to 0 when the stored value is null (
NVL(TO_NUMBER(...),0)).
Common Use Cases and Queries
The view is typically queried to extract detailed YEA pay value breakdowns for an assignment action, for reconciliation, or for feeding the Japanese SOE layout.
- Retrieve all YEA-class input values for a specific assignment action ordered by display sequence.
- Aggregate total YEA amounts per assignment action or payroll action for reconciliation.
- Feed localized SOE output by consuming the resolved value names and numeric results directly.
A representative query is:
SELECT assignment_action_id, run_result_id, input_value_id, value_name, result_value FROM apps.pay_jp_soe_run_yea_v WHERE assignment_action_id = :p_assignment_action_id ORDER BY display_sequence;
Analysts may also aggregate totals with SELECT assignment_action_id, SUM(result_value) FROM apps.pay_jp_soe_run_yea_v GROUP BY assignment_action_id;. Because the view enforces the YEA_CLASS_ID parameter and PAY/PA statuses, callers do not need to replicate that filtering logic.
-
View: PAY_JP_SOE_RUN_YEA_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_SOE_RUN_YEA_V·↳ HR_API·↳ HR_JP_PARAMETERS·↳ HR_LOOKUPS·Explore PAY module →
-
View: PAY_JP_SOE_RUN_YEA_V 12.1.1
This view is used for Japanese localization only.
APPS.PAY_JP_SOE_RUN_YEA_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_JP_PARAMETERS·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_SOE_RUN_DEDUCTIONS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_JP_PARAMETERS·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_SOE_RUN_DEDUCTIONS_V·↳ HR_API·↳ HR_JP_PARAMETERS·↳ HR_LOOKUPS·Explore PAY module →