Search Results ytd_val




Overview
Explore in AI Chat

Overview

PAY_MX_TAXABLE_BENEFITS_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) module, defined for the Mexican (MX) localization. It exposes taxable benefit balances calculated at the assignment, tax unit, and payroll action level, drawing on the balance framework maintained by the payroll engine. The view is a reporting and integration artifact rather than a transactional entity; it consolidates assignment action context, payroll action context, and computed balance values into a single row-per-balance record.

The view is particularly relevant to users searching for the ytd_val column, which represents the year-to-date taxable benefit value for a given balance type and assignment. Alongside ytd_val, the view exposes run_val, the corresponding value for the run associated with the assignment action. Both values are derived at query time through calls to the PAY_AC_UTILITY package, meaning the view returns live balance calculations rather than stored snapshots. Its status is documented as VALID in the 12.2.2 ETRM repository, indicating the object is compiled and usable in the runtime APPS schema for both 12.1.1 and 12.2.2 environments.

Underlying Base Objects

The view is defined over seven base objects, all referenced through APPS synonyms, plus one package:

The joins are joined between payroll actions, assignment actions, balance types, defined balances, and balance attributes. Critically, PAY_BAL_ATTRIBUTE_DEFINITIONS filters on ATTRIBUTE_NAME = 'TAXABLE BENEFITS', BUSINESS_GROUP_ID IS NULL, and LEGISLATION_CODE = 'MX', which confines the view to Mexican localization semantics. The EXISTS clause against PAY_RUN_BALANCES further restricts rows to those where a run balance exists between the start of the payroll action's effective year and the effective date.

Key Columns

Common Use Cases and Queries

Typical uses include year-end Mexican payroll reporting, taxable benefit reconciliation, and integration extracts feeding statutory or third-party tax filings. The most frequent access pattern filters on assignment and year-to-date value:

  • Retrieve year-to-date taxable benefits by assignment: SELECT assignment_id, tax_unit_id, balance_name, ytd_val FROM apps.pay_mx_taxable_benefits_v WHERE assignment_id = :p_assignment_id AND date_paid BETWEEN :p_start AND :p_end;
  • Compare run versus YTD amounts: SELECT balance_name, run_val, ytd_val FROM apps.pay_mx_taxable_benefits_v WHERE tax_unit_id = :p_tax_unit AND business_group_id = :p_bg;
  • Aggregate taxable benefit totals per balance for reporting: SELECT balance_name, SUM(ytd_val) FROM apps.pay_mx_taxable_benefits_v WHERE date_earned BETWEEN :p_from AND :p_to GROUP BY balance_name;

Because RUN_VAL and YTD_VAL are computed through PAY_AC_UTILITY.GET_VALUE, query cost scales with the number of assignment actions and balance types returned; filtering aggressively on assignment, tax unit, and effective date before aggregation is advisable to maintain performance.