Search Results pay_hk_asg_element_payments_v




Overview
Explore in AI Chat

Overview

PAY_HK_ASG_ELEMENT_PAYMENTS_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) module, valid in both 12.1.1 and 12.2.2. It is a Hong Kong (HK) localization object designed to consolidate assignment-level element payment amounts for payroll reporting and payslip production. The view returns run-result value data joined to assignment actions, payroll actions, element types, and element classifications, filtering and re-labeling records relevant to Hong Kong statutory and voluntary schemes — most notably Mandatory Provident Fund (MPF) arrangements.

Rather than presenting raw payroll run results, the view applies DECODE logic to map element names into an ordered reporting hierarchy and to derive user-friendly reporting labels. It is therefore a presentation-layer object, typically consumed by payslip reports, regulatory extracts, and interfaces that must display MPF-related earnings, deductions, and employer liabilities in a fixed, business-meaningful sequence.

Underlying Base Objects

The view is defined over a mix of base tables, views, and packages. Documented referenced objects include:

The view joins these objects to align each element payment with its assignment, action, and classification, and it aggregates result values through SUM(NVL(PRRV.RESULT_VALUE, 0)).

Key Columns

Common Use Cases and Queries

Typical consumers include Hong Kong payslip reports, MPF reporting extracts, and reconciliation queries that require element payments grouped by classification and scheme. A representative query lists ordered MPF-related payments for an assignment:

  • SELECT assignment_id, element_reporting_name, classification_name, payment_amount FROM pay_hk_asg_element_payments_v WHERE assignment_id = :p_assignment_id ORDER BY element_name_sort, processing_priority;
  • SELECT classification_name, SUM(payment_amount) FROM pay_hk_asg_element_payments_v WHERE assignment_action_id = :p_action_id GROUP BY classification_name;
  • SELECT element_reporting_name, payment_amount FROM pay_hk_asg_element_payments_v WHERE classification_name = 'EMPLOYER LIABILITIES' ORDER BY element_name_sort;

The view is read-only reporting infrastructure; it should not be treated as a transactional interface, and queries should be filtered by assignment or action to avoid full-scan overhead across payroll history.