Results for “sal_si_prem_class_id”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_JP_SOE_RUN_DEDUCTIONS_V is a reporting view used by the Oracle E-Business Suite Japanese payroll localization to present Statement of Earnings (SOE) deduction and social insurance premium class information for a payroll run. The view assembles run result values for assignment actions, translating technical element and input value identifiers into user-facing names by joining through HR_JP_PARAMETERS, HR_LOOKUPS, and PAY_INPUT_VALUES_F. Its purpose is to give report writers and integrators a flattened, run-scoped picture of deductions, social insurance premiums, yearly tax deductions, and bonus-related class elements as configured through the PAYJPSOE parameter owner. The view is defined with outer joins (notably piv.element_type_id(+) and nvl on run_result_id) so that elements are surfaced even when no corresponding input value row exists, defaulting the reported value to zero. In Oracle EBS 12.1.1 and 12.2.2 the view resides in the APPS schema and is intended for read-only reporting rather than transactional processing.

Underlying Base Objects

The documented base objects for this view include the packages and synonyms HR_API, HR_JP_PARAMETERS, HR_LOOKUPS, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, and PAY_SUB_CLASSIFICATION_RULES_F. The core inline query joins PAY_PAYROLL_ACTIONS to PAY_ASSIGNMENT_ACTIONS on payroll_action_id, then to PAY_RUN_RESULTS on assignment_action_id, filtered to run results with status in ('P','PA'). Element types are resolved through PAY_ELEMENT_TYPES_F and its translated table PAY_ELEMENT_TYPES_F_TL, filtered by the session language via userenv('LANG'). The Japanese localization parameters in HR_JP_PARAMETERS (owner 'PAYJPSOE') drive the classification selection, while PAY_SUB_CLASSIFICATION_RULES_F is consulted for the YEA_CLASS_ID special case. PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_ELEMENT_TYPES_F_TL are date-effective, and the query enforces the effective_date ranges accordingly. HR_LOOKUPS supplies name translation for input value names.

Key Columns

  • assignment_action_id — identifier of the assignment action that produced the run result.
  • Element name or reporting name — returned via nvl(v1.reporting_name, v1.element_name), providing the localized, preferred display name for the element.
  • run_result_id — the run result identifier used to link to PAY_RUN_RESULT_VALUES.
  • Element value — returned as nvl(to_number(prrv.result_value),0), the numeric result value for the input value, defaulting to zero when absent.

Implicit supporting columns include classification_id, run_result_id, element_type_id, effective_date, and input value names, which are used internally for filtering and joins.

Common Use Cases and Queries

The view is typically used to build SOE extracts, reconcile deduction and social insurance premium amounts per assignment action, and feed downstream reporting or interfaces for Japanese payroll. A representative query follows.

  • SELECT assignment_action_id, run_result_id FROM apps.pay_jp_soe_run_deductions_v WHERE assignment_action_id = :assignment_action_id;
  • SELECT * FROM apps.pay_jp_soe_run_deductions_v WHERE run_result_id = :run_result_id;

Because the view is pre-joined and localized, it is best consumed directly rather than re-deriving the joins manually; the same classification and effective-dating logic must be preserved to avoid discrepancies against the Japanese payroll SOE report.