Results for “ben_los_det”

28 results




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

Overview

The view APPS.BENBV_ELIG_SCHEDD_HRS_PRTE_V is a business-validated (BV) database view within the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents the defined rows of the Scheduled Hours eligibility profile participation and eligibility criteria rule, exposing the configuration of worked-hours thresholds that determine whether a person qualifies for a benefits program or plan. The view surfaces a subset of columns from the underlying flexfield-based rules table and enriches them with decoded lookup values, making it suitable for reporting, data extraction, and integration where raw coded values would otherwise require additional interpretation.

Because the view applies a security profile filter on the business group, its result set is automatically restricted to the business group of the session, or to all business groups when no security profile is active. This makes the view safe for use in multi-organization deployments and appropriate for both report publishers and interface programs.

Underlying Base Objects

The view is defined over a single referenced base object: the synonym BEN_ELIG_SCHEDD_HRS_PRTE_F, which resolves to the underlying BEN scheduled-hours eligibility profile rules table. It also references the HR_BIS package for lookup decoding through its BIS_DECODE_LOOKUP function.

The WHERE clause applies ESH.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ESH.BUSINESS_GROUP_ID), restricting rows to the current business group when a security profile is set. The view is created WITH READ ONLY, so it cannot be used for DML. The user's search term ben_los_det corresponds to the lookup type decoded for the DETERMINATION_CD column, which explains why this view is returned for that search.

Key Columns

Common Use Cases and Queries

Typical uses include reporting eligibility profile criteria by hours, validating configuration during implementation, and extracting decoded rule definitions for interfaces. The following query lists active scheduled-hours criteria for a given eligibility profile:

  • SELECT eligy_prfl_id, hrs_num, max_hrs_num, freq_cd, determination_cd, exclud_flag FROM apps.benbv_elig_schedd_hrs_prte_v WHERE eligy_prfl_id = :p_profile_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY ordr_num;

To review decoded determination and rounding values for auditing:

  • SELECT elig_schedd_hrs_prte_id, determination_cd, freq_cd, rounding_cd, hrs_num FROM apps.benbv_elig_schedd_hrs_prte_v WHERE created_by = :p_user;

Because the view is read-only and security-filtered by business group, it is well suited to concurrent program extracts and BI Publisher data models without additional row-level security coding.