Search Results get_years_in_position

Overview

BEN_CWB_PERSON_INFO_PKG is an APPS-owned PL/SQL package within the Oracle EBS Advanced Benefits (BEN) module, specifically supporting the Compensation Workbench (CWB) feature set. Its core responsibility is to assemble, derive, and persist person-level compensation information used by Compensation Workbench planners and summary processes. The package aggregates workforce attributes — job tenure, grade characteristics, salary currency, FTE factor, and comparatio/range positioning — into the BEN_CWB_PERSON_INFO staging table, which downstream CWB components consume. It is classified as an OTHER API in the ETRM registry and remains in VALID status under both 12.1.1 and 12.2.2. Its exposure of sixteen documented procedures and functions positions it as a reusable calculation library rather than a single-entry API, invoked by multiple sibling packages including BEN_CWB_DYN_CALC_PKG, BEN_CWB_CD_SUMMARY_PKG, BEN_CWB_REFRESH_PKG, and BEN_MANAGE_CWB_LIFE_EVENTS.

Key Procedures and Functions

The documented procedures fall into four functional clusters:

• Tenure calculations: GET_YEARS_IN_JOB, GET_YEARS_IN_POSITION, and GET_YEARS_IN_GRADE return elapsed service metrics. These populate CWB fields used in eligibility and award allocation logic.
• Grade structure attributes: GET_GRD_MIN_VAL, GET_GRD_MAX_VAL, and GET_GRD_MID_POINT extract the minimum, maximum, and midpoint values of an employee's grade rate range. GET_GRD_PCT_IN_RANGE derives the percentage of the range occupied by the current salary.
• Statistical positioning: GET_GRD_COMPARATIO, GET_GRD_QUARTILE, GET_GRD_QUINTILE, and GET_GRD_DECILE return the employee's comparative standing within the grade, supporting distribution analysis in CWB worksheets.
• Refresh and utility routines: REFRESH_PERSON_INFO and REFRESH_PERSON_INFO_GROUP_PL regenerate records for an individual or a group of persons (the _GROUP_PL variant supporting a PL/SQL group). REFRESH_FROM_MASTER repopulates staging data from master sources. GET_SALARY_CURRENCY and GET_FTE_FACTOR return the currency code and full-time-equivalent multiplier applied to compensation amounts.

Tables Accessed

Via APPS synonyms, the package reads primarily from HR and BEN transactional tables and writes to its own staging table:

• BEN_CWB_PERSON_INFO — the primary target for REFRESH operations, holding person-level CWB attributes.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — source of person, assignment, grade, job, position, and FTE data.
• PAY_GRADE_RULES_F — grade rate ranges used by MIN/MAX/MID calculations.
• PER_APPRAISALS and PER_PAY_BASES — performance ratings and salary basis information.
• BEN_CWB_PL_DSGN, BEN_PER_IN_LER, BEN_PL_EXTRA_INFO — plan design, life event, and extra information context.
• HR_ORGANIZATION_INFORMATION, PAY_PEOPLE_GROUPS, PAY_ALL_PAYROLLS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PER_EVENTS — organizational, payroll, and event context required for eligibility and grouping logic.

Usage Notes

The package is normally invoked indirectly. CWB worksheet generation, refresh concurrent programs, and life-event processing (BEN_MANAGE_CWB_LIFE_EVENTS) call REFRESH_PERSON_INFO and its variants to synchronize person data before planners access the Compensation Workbench. Derived functions such as GET_GRD_COMPARATIO and GET_FTE_FACTOR are called by BEN_CWB_DYN_CALC_PKG during dynamic award calculations, and by BEN_EVALUATE_ELIG_PROFILES and BEN_EVALUATE_RATE_PROFILES during eligibility and rate evaluation. PER_SALADMIN_UTILITY references it for salary administration validation. Customers extending CWB should treat this package as a stable dependency; direct invocation is uncommon, but custom refresh logic may call REFRESH_PERSON_INFO_GROUP_PL after bulk data loads. Because it is an OTHER-classified API, Oracle does not guarantee interface stability across patches, and any custom code should verify signatures against the current application version.