Search Results qtd_val




Overview
Explore in AI Chat

Overview

PAY_US_FED_ER_WAGES_RBR_V is an APPS-owned view in the Oracle E-Business Suite Payroll (PAY) product, delivered for the United States federal legislative context. It presents, for each assignment action processed within a qualifying payroll action, the employer-side (ER) federal wage and tax balance information resolved at multiple time scopes. The view is a reporting and integration artifact rather than a transactional entity: it exposes payroll run results in a flattened, query-friendly shape suitable for extract programs, reconciliation reports, and downstream tax filing interfaces.

The "RBR" component of the name reflects the run-balance orientation of the object, indicating that the values presented are derived from payroll run balances rather than stored balances. The view is particularly relevant to the "qtd_val" query pattern, because it surfaces current, run, quarter-to-date, and year-to-date values side by side for the same assignment action and tax type. This structure allows a single query to return a full period-perspective profile of employer federal wage balances without repeated self-joins or procedural calls.

Underlying Base Objects

The documented base objects referenced by the view are PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_US_FED_ER_WAGE_TYPES_V, PAY_RUN_BALANCES, PAY_BALANCE_ATTRIBUTES, and PAY_BAL_ATTRIBUTE_DEFINITIONS, together with the packages PAY_US_BALANCE_VIEW_PKG and PAY_US_TAXBAL_VIEW_PKG.

  • PAY_ASSIGNMENT_ACTIONS (PAA) supplies the assignment, tax unit, assignment action, action status, and payroll action identifiers that define the driving row.
  • PAY_PAYROLL_ACTIONS (PPA) supplies action type, effective date, payroll action ID, and date earned; the view restricts action types to 'Q', 'R', 'V', 'B', and 'I', and filters on the date earned or effective date falling within the wage type effective range.
  • PAY_US_FED_ER_WAGE_TYPES_V (PETV) is the employer federal wage type definition view, contributing the tax type ID, EE/ER code, limit tax flag, tax domain code, tax type code, balance category code, user reporting name, element name and type, effective dates, business group, processing priority, and legislation code.
  • PAY_US_BALANCE_VIEW_PKG and PAY_US_TAXBAL_VIEW_PKG are invoked as inline PL/SQL functions to resolve view mode, the calculation-all-timettypes flag, and the four balance perspectives.
  • PAY_RUN_BALANCES, PAY_BALANCE_ATTRIBUTES, and PAY_BAL_ATTRIBUTE_DEFINITIONS are the underlying balance storage and definition objects whose data is resolved through the tax balance package call.

Key Columns

Common Use Cases and Queries

Typical uses include employer federal tax reconciliation, quarter-to-date and year-to-date wage reporting, pre-filing validation of federal 941-style accumulations, and extraction for downstream payroll interfaces. Because the four scopes are returned together, a single query can compare run-level activity against quarter and year accumulations for the same assignment action.

SELECT assignment_id,
       tax_unit_id,
       tax_type_code,
       ee_or_er_code,
       run_val,
       qtd_val,
       ytd_val
FROM   apps.pay_us_fed_er_wages_rbr_v
WHERE  payroll_action_id = :p_payroll_action_id
AND    qtd_val <> 0
ORDER  BY assignment_id, tax_type_code;

Focused retrieval of the quarter-to-date figure alone may be performed as follows:

SELECT assignment_action_id, tax_type_code, qtd_val
FROM   apps.pay_us_fed_er_wages_rbr_v
WHERE  tax_unit_id = :p_tax_unit_id
AND    action_type IN ('Q','R','V','B','I');

Performance characteristics are governed by the inline package calls, which execute per row for each of the four scopes. Queries should therefore be constrained by payroll action, tax unit, or assignment action to limit the driving set. All access should be performed through the APPS schema or a synonym, and the view should be treated as read-only.