Search Results fr_pension_group

Overview

APPS.HR_FR_PENSION_GROUPS_V is a reporting view within the Oracle E-Business Suite Human Resources (HR) module. It exposes French pension group organization units as defined in the HR organization hierarchy, presenting the subset of organizations classified under the French pension group classification along with their identifying and descriptive attributes. The view is typically consumed in French localization reporting, statutory extracts, and integrations that must identify which organizations are flagged as pension groups (caisses de retraite) for a given business group.

The view filters on the organization classification context 'CLASS' and the classification value 'FR_PENSION_GROUP', retaining only those organization records whose secondary classification information value is 'Y'. This design means only organizations explicitly enabled as French pension groups appear. The view also resolves the organization name in the current session language through USERENV('LANG'), ensuring translated names are returned for the running session's locale.

Underlying Base Objects

The view is defined over the following documented base objects:

• HR_ALL_ORGANIZATION_UNITS (SYNONYM) — provides the core organization unit record, including organization_id, business_group_id, date_from, date_to, location_id, internal_address_line, and comments (aliased OU1).
• HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — the translation table supplying the organization name (aliased OUT1), joined on organization_id and the session language.
• HR_ORGANIZATION_INFORMATION (SYNONYM) — holds the classification context and flexfield values (aliased OI2), used to identify the 'FR_PENSION_GROUP' classification and the 'Y' flag in org_information2.
• HR_LOCATIONS (VIEW) — supplies the location_code (aliased OL), joined to the organization via location_id using an outer join.
• HR_GENERAL (PACKAGE) — referenced as a supporting object, generally used for HR utilities invoked in related HR logic.

The joins follow the HR organization model: organization units link to their translation rows, to their classification information rows, and optionally to location records.

Key Columns

• ORGANIZATION_ID — Primary identifier of the organization unit.
• BUSINESS_GROUP_ID — The business group to which the organization belongs.
• NAME — Language-specific organization name resolved from the translation table.
• DATE_FROM / DATE_TO — Effective date range of the organization record.
• INTERNAL_ADDRESS_LINE — Internal address line associated with the organization.
• LOCATION_ID / LOCATION_CODE — Location reference and its code (via outer join, so location_code may be null).
• COMMENTS — Free-text comments on the organization unit.
• ORG_INFORMATION2 — The classification value from HR_ORGANIZATION_INFORMATION; filtered to 'Y' to indicate an active pension group.

Common Use Cases and Queries

Typical uses include validating which organizations are configured as French pension groups, feeding pension contribution extracts, and joining the pension group list to assignment or payroll data for statutory reporting.

A representative query listing all pension groups for a business group:

SELECT organization_id,
       business_group_id,
       name,
       date_from,
       date_to,
       location_code
FROM   apps.hr_fr_pension_groups_v
WHERE  business_group_id = :p_business_group_id
AND    SYSDATE BETWEEN NVL(date_from, SYSDATE)
                   AND NVL(date_to, SYSDATE);

The view is read-only and should be treated as a reporting convenience layer; organizations are maintained through the standard HR organization and classification setup rather than direct DML.