Search Results ben_dpnt_cvg_start




Overview
Explore in AI Chat

Overview

APPS.BENBV_ELIG_MLTRY_STAT_CVG_V is a read-only reporting view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents military status dependent coverage eligibility rules defined at the dependent coverage eligibility profile level. The view is a business-facing ("BV") construct that flattens the underlying configuration table BEN_ELIG_MLTRY_STAT_CVG_F into a denormalized, query-friendly form suitable for reports, extracts, and integration interfaces. It exposes effective-dated rows, descriptive flexfield placeholders, decoded lookup meanings, identifier columns, and standard WHO (audit) columns. Because the view is defined with the WITH READ ONLY clause, it cannot be used as the target of DML and is intended strictly for retrieval. The view also enforces row-level security through the HR_BIS.GET_SEC_PROFILE_BG_ID function, restricting returned rows to the business group of the session's security profile when one is set.

Underlying Base Objects

The view is defined over a single base object, BEN_ELIG_MLTRY_STAT_CVG_F, referenced here through a synonym, which supplies the eligibility profile and military status coverage rule rows. The military status code and both the coverage start and coverage end codes are translated at runtime by the HR_BIS package function BIS_DECODE_LOOKUP, which resolves the stored lookup codes into their display meanings. The business group filter in the WHERE clause calls HR_BIS.GET_SEC_PROFILE_BG_ID so that the result set conforms to the operator's security profile. The documented base objects are therefore BEN_ELIG_MLTRY_STAT_CVG_F and the HR_BIS package. No joins to additional tables are present in the view text; instead, lookup decoding is performed through function calls.

Key Columns

Common Use Cases and Queries

Typical uses include auditing military status coverage rules per eligibility profile, validating that coverage start and end codes map to expected lookup meanings, and exporting eligibility configuration for conversion or integration. The decoded columns allow report authors to avoid separate lookup joins. A basic retrieval by profile follows:

SELECT elig_m ltry_stat_cvg_id, cvg_strt_cd, cvg_thru_cd, effective_start_date, effective_end_date FROM apps.benbv_elig_mltry_stat_cvg_v WHERE dpnt_cvg_eligy_prfl_id = :p_profile_id ORDER BY effective_start_date;

To inspect the dependency coverage end lookups referenced by the view, filter on the decoded end value or examine CVG_THRU_CD directly and resolve it with HR_BIS.BIS_DECODE_LOOKUP against 'BEN_DPNT_CVG_END'. Because the view is read-only and security-profile aware, queries executed under an operator's session return only rows for the applicable business group.