Search Results pay_us_gtn_deduct_v




Overview
Explore in AI Chat

Overview

PAY_US_GTN_DEDUCT_V is a valid, APPS-owned reporting view within the Oracle E-Business Suite Payroll (PAY) module, with specific applicability to United States (US) legislation payroll processing. Its name encodes its function: "GTN" refers to Gross-to-Net calculation, and "DEDUCT" indicates it exposes deduction-related balance and element data. The view is designed to resolve the running or earned values of deduction balances against assignment actions and payroll actions, providing a denormalized, query-ready result set for gross-to-net reporting, reconciliation, and integration scenarios.

The view is especially significant because of its direct exposure of the CALC_ALL_TIMETYPES column, which is populated from PAY_US_BALANCE_VIEW_PKG.GET_CALC_ALL_TIMETYPES_FLAG. This column indicates whether the associated balance element is configured to calculate across all time types, a configuration relevant to US payroll gross-to-net processing. The view also exposes a VIEW_MODE column sourced from PAY_US_BALANCE_VIEW_PKG.GET_VIEW_MODE, and a RUN_VALUE computed by PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM.

Underlying Base Objects

The view is defined over four base tables (referenced as APPS synonyms) and several supporting objects:

  • PAY_ASSIGNMENT_ACTIONS (PAA) — supplies the assignment action, action status, tax unit, and payroll action identifiers.
  • PAY_PAYROLL_ACTIONS (PPA) — supplies the action type, effective date, and date earned used to constrain the balance element's effective dating.
  • PAY_BALANCE_TYPES (PBT) — supplies the balance name, balance type ID, and unit of measure.
  • PAY_RUN_RESULTS (PRR) — used in an EXISTS subquery to confirm a run result exists for the assignment action and deduction element type.
  • PAY_US_DEDUCTION_TYPES_V (DEDUCT) — the deduction element definition view providing element name, type, classification, reporting names, processing priority, and the ELEMENT_INFORMATION10 join key.
  • PAY_US_BALANCE_VIEW_PKG and PAY_US_TAXBAL_VIEW_PKG — PL/SQL packages supplying the CALC_ALL_TIMETYPES flag, VIEW_MODE, and RUN_VALUE calculations.

The join between PAY_US_DEDUCTION_TYPES_V.ELEMENT_INFORMATION10 and PAY_BALANCE_TYPES.BALANCE_TYPE_ID is the central linkage tying deduction elements to their corresponding balance definitions. The view filters to payroll action types 'Q', 'R', and 'V' and requires a matching PAY_RUN_RESULTS row.

Key Columns

Common Use Cases and Queries

Typical uses include gross-to-net reconciliation, deduction balance reporting, and auditing time-type calculation flags. A representative query to inspect CALC_ALL_TIMETYPES for a given assignment action is:

  • SELECT ASSIGNMENT_ACTION_ID, ELEMENT_NAME, BALANCE_NAME, CALC_ALL_TIMETYPES, RUN_VALUE FROM APPS.PAY_US_GTN_DEDUCT_V WHERE ASSIGNMENT_ACTION_ID = :p_action_id;
  • SELECT ELEMENT_NAME, BALANCE_NAME, VIEW_MODE, CALC_ALL_TIMETYPES FROM APPS.PAY_US_GTN_DEDUCT_V WHERE CALC_ALL_TIMETYPES = 'Y';
  • SELECT PAYROLL_ACTION_ID, ACTION_TYPE, COUNT(*) FROM APPS.PAY_US_GTN_DEDUCT_V GROUP BY PAYROLL_ACTION_ID, ACTION_TYPE;

Because the view is not secured by row-level legislation predicates beyond the US deduction view, queries should always be scoped by business group or payroll action to avoid cross-legislation result sets.