Search Results province_abbrev




Overview
Explore in AI Chat

Overview

APPS.PAY_CA_PROV_ER_V is a supplementary Oracle EBS view residing in the APPS schema and registered under FND Design Data as PAY.PAY_CA_PROV_ER_V. It belongs to the Canadian (CA) payroll legislation family within Oracle Payroll and is designed to simplify forms coding by presenting province-level balance and assignment action information in a flattened, query-ready format. The view exposes data relevant to Canadian provincial tax and balance reporting, joining assignment action records to province definitions and rolling up balance values across several time dimensions (current, run, pay date, month, quarter-to-date, period-to-date, and year-to-date).

The view is classified as a "supplementary view used to simplify forms coding," and Oracle explicitly warns that querying or altering data through this view is not recommended, as its definition may change dramatically in subsequent minor or major releases. It should therefore be treated as an internal implementation object rather than a stable integration interface. Its primary consumers are Oracle Forms-based Payroll windows that need to display province-specific balance information for an assignment.

Underlying Base Objects

The view is defined over a combination of synonyms and packages. The documented base objects include:

The dependency chain confirms that PAY_CA_PROV_ER_V is a Canadian payroll-specific construct layered on core payroll action and balance infrastructure.

Key Columns

Common Use Cases and Queries

Typical usage involves retrieving province-tagged balance values for an assignment or a set of payroll actions, for example to reconcile provincial tax balances or to populate a custom report. A representative query is:

  • SELECT assignment_id, province_abbrev, balance_name, ytd_value, qtd_value FROM apps.pay_ca_prov_er_v WHERE assignment_id = :p_assignment_id ORDER BY province_abbrev;
  • SELECT province_abbrev, SUM(ytd_value) FROM apps.pay_ca_prov_er_v WHERE business_group_id = :p_bg_id AND legislation_code = 'CA' GROUP BY province_abbrev;

Because Oracle does not support direct querying of this view, production integrations should prefer the underlying balance APIs and base tables. Nevertheless, the view remains valuable for understanding how Oracle Forms surfaces Canadian provincial balance data within the 12.1.1 and 12.2.2 releases.