Results for “parent_spine_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PER_CAGR_ENTITLEMENT_LINES_V view is a Human Resources (PER) reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the entitlement line definitions used by the Collective Agreement (CAGR) grade step progression framework. Its principal purpose is to present the raw, coded values stored in the underlying entitlement lines table in a user-readable form. Whereas the base table stores foreign-key identifiers, lookup codes, and value-set codes, this view resolves those codes into descriptive text through lookup decoding and a PL/SQL utility call, thereby supporting reporting, data extraction, and integration scenarios where human-readable descriptions are required.

The view conforms to the standard Oracle EBS pattern of pairing a "_F" base table with a "_V" view that adds translated or decoded columns. It is secured implicitly by joining to FND_SESSIONS on the current session, and it filters records by the session's effective date, ensuring that only rows valid as of the user's effective date are returned.

Underlying Base Objects

The view is defined over the synonym PER_CAGR_ENTITLEMENT_LINES_F, which is the primary transactional table holding entitlement line records. It is joined to several supporting objects:

• PER_CAGR_ENTITLEMENT_LINES_F — the driving synonym containing entitlement line definitions.
• FND_SESSIONS — supplies the session ID and effective date used to filter valid rows.
• PER_GRADE_SPINES_V — provides the grade spine description (D_GRADE) for the associated grade spine.
• PER_PARENT_SPINES — supplies the parent spine name.
• PER_SPINAL_POINT_STEPS_V — joined three times to resolve the step, from-step, and to-step into spinal point descriptions.
• BEN_ELIGY_PRFL — outer-joined to provide the eligibility profile name.
• HR_GENERAL (package) — used to decode the CAGR_MANDATORY, CAGR_STATUS, and CAGR_DEFAULT lookups.
• PER_CAGR_UTILITY_PKG (package) — function GET_NAME_FROM_VALUE_SET resolves VALUE, RANGE_FROM, and RANGE_TO codes into names.

All joins to the descriptive objects are outer joins, so the view still returns entitlement lines even when associated grade spines, steps, or eligibility profiles are not defined.

Key Columns

The view exposes the primary key CAGR_ENTITLEMENT_LINE_ID along with the following significant columns:

• MANDATORY / MANDATORY_DESC — the raw mandatory flag and its decoded lookup description.
• VALUE / VALUE_DESC — the entitlement value code and its resolved name from the value set. VALUE_DESC is the column most commonly targeted by users searching for "value_desc".
• RANGE_FROM / RANGE_FROM_DESC and RANGE_TO / RANGE_TO_DESC — the range boundaries and their resolved descriptions.
• STATUS / STATUS_DESC — the record status code and its decoded description.
• GRADE_NAME, PARENT_SPINE_NAME — descriptive names of the grade spine and parent spine.
• SPINAL_POINT, FROM_SPINAL_POINT, TO_SPINAL_POINT — spinal point descriptions for the step, from-step, and to-step.
• ELIGIBLITY_PROFILE_NAME — the eligibility profile name, defaulting to a decoded lookup value when ELIGY_PRFL_ID is zero.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range driving session-based filtering.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

This view is typically queried to report on entitlement line configuration, to validate that value-set codes resolve correctly, and to feed downstream integrations requiring descriptive text rather than codes. Because the view is session-filtered, it should be queried from within an initialized EBS session.

A typical query retrieving readable entitlement lines is:

• SELECT cagr_entitlement_line_id, value, value_desc, range_from_desc, range_to_desc, grade_name, status_desc FROM per_cagr_entitlement_lines_v WHERE cagr_entitlement_id = :p_entitlement_id;
• SELECT cagr_entitlement_line_id, mandatory_desc, eligibility_profile_name, spinal_point, from_spinal_point, to_spinal_point FROM per_cagr_entitlement_lines_v WHERE effective_start_date <= SYSDATE AND effective_end_date >= SYSDATE;

These queries illustrate the view's value as a decoding layer, converting stored identifiers into the descriptive labels required for operational reporting and integration.