Search Results hr_fr_pension_prv_grp_v




Overview
Explore in AI Chat

Overview

HR_FR_PENSION_PRV_GRP_V is a valid Oracle E-Business Suite view owned by the APPS schema within the PER (Human Resources) product family. It presents a consolidated, French-localization-specific listing of pension providers and pension groups for a given organization or business group. The view is a union of two more granular views — HR_FR_PENSION_PROVIDERS_V and HR_FR_PENSION_GROUPS_V — and exposes a uniform set of descriptive and location attributes for both. Its principal role is to support legislative reporting and integration scenarios that require a single source of pension provider and pension group records, particularly where an internal address line, location code, and enabled status must be surfaced together.

The object is documented as VALID, meaning it is compiled and available for query use in both 12.1.1 and 12.2.2 environments. Because it is a view rather than a table, it stores no data of its own and always reflects the current state of its underlying pension provider and pension group definitions.

Underlying Base Objects

The documented referenced base objects are HR_FR_PENSION_GROUPS_V (VIEW), HR_FR_PENSION_PROVIDERS_V (VIEW), and HR_GENERAL (PACKAGE).

  • HR_FR_PENSION_PROVIDERS_V supplies pension provider records. When unioned, it contributes non-null values for the CODE and TYPE columns.
  • HR_FR_PENSION_GROUPS_V supplies pension group records. In the union, its CODE and TYPE positions are projected as NULL, since these attributes apply specifically to providers.
  • HR_GENERAL is the standard HR security and utility package invoked by the underlying views to resolve business group scoping and access.

Both contributing views share an identical projected column list, which is what permits the UNION without implicit casting. The union is not a UNION ALL, so duplicate rows across providers and groups are suppressed according to the projected column values.

Key Columns

The view exposes eleven columns, all carried through from the two contributing views:

  • ORGANIZATION_ID — The organization context of the provider or group record.
  • BUSINESS_GROUP_ID — The business group that owns the record; central to HR security and legislative filtering.
  • NAME — The descriptive name of the pension provider or pension group.
  • DATE_FROM / DATE_TO — The effective date range for which the record is valid.
  • INTERNAL_ADDRESS_LINE — The internal address line associated with the provider or group, typically the location description or internal reference used on pension declarations.
  • LOCATION_ID — Foreign key to the location definition.
  • LOCATION_CODE — The business-facing location code corresponding to LOCATION_ID.
  • CODE — The provider code; NULL for rows originating from HR_FR_PENSION_GROUPS_V.
  • TYPE — The provider type; NULL for group-originated rows.
  • ENABLED — Indicates whether the provider or group is currently active.

Common Use Cases and Queries

Typical uses include French pension regulatory extracts, validation of active providers and groups for a business group, and data reconciliation between provider and group definitions where both must expose the same address and location attributes.

Listing all enabled records for a business group:

  • SELECT name, internal_address_line, location_code, code, type, enabled FROM hr_fr_pension_prv_grp_v WHERE business_group_id = :p_bg_id AND enabled = 'Y';

Identifying the source of a row by CODE presence:

  • SELECT name, CASE WHEN code IS NOT NULL THEN 'PROVIDER' ELSE 'GROUP' END AS record_type, internal_address_line FROM hr_fr_pension_prv_grp_v WHERE enabled = 'Y';

Point-in-time validation against effective dates:

  • SELECT name, date_from, date_to, internal_address_line FROM hr_fr_pension_prv_grp_v WHERE SYSDATE BETWEEN date_from AND NVL(date_to, SYSDATE + 1);