Search Results hours_run_val




Overview
Explore in AI Chat

Overview

APPS.PAY_MX_HOURLY_EARNINGS_V is an Oracle E-Business Suite internal view owned by the APPS schema, registered under FND Design Data as PAY.PAY_MX_HOURLY_EARNINGS_V. It is a Mexico (MX) legislative localization object whose purpose is to present, on a single row, the earnings and hours balance information associated with an assignment's payroll action for a defined period. The view joins payroll action context (assignment, tax unit, payroll action, action status and type, dates paid and earned, business group and run type) to the run and year-to-date values of a selected earnings balance and a corresponding hours balance.

Its principal role is to support Oracle payroll processes and statutory reporting for Mexican payroll, notably hourly earnings reporting where both a monetary balance and a time (hours) balance must be reported side by side. The view carries the explicit Oracle restriction: "Oracle Internal Use Only — Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs." Customers and integrators may query it for diagnostics or custom reporting, but it is not a supported public interface and its definition may change without notice between releases such as 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over synonyms and packaged PL/SQL rather than raw tables. The documented dependencies are:

The view is not referenced by any other database object, confirming its role as a terminal reporting/read-only construct.

Key Columns

Common Use Cases and Queries

Typical uses include validating that hourly earnings have been written with a matching hours balance, reconciling run versus YTD values for a payroll period, and extracting Mexico hourly earnings data for statutory or internal reporting.

Selecting the hours balance name and its values for a given assignment action:

  • SELECT assignment_id, hours_bal_name, hours_run_val, hours_ytd_val FROM apps.pay_mx_hourly_earnings_v WHERE assignment_action_id = :p_action_id;

Reconciling earnings against hours for a date range:

  • SELECT assignment_id, date_earned, earn_bal_name, earn_run_val, hours_bal_name, hours_run_val FROM apps.pay_mx_hourly_earnings_v WHERE date_earned BETWEEN :p_start AND :p_end AND business_group_id = :p_bg_id ORDER BY assignment_id, date_earned;

Because the view is internal and unsupported, any query should be validated against the current release, and production integrations should prefer supported payroll balance extraction methods where available.