Search Results dflt_flag_m




Overview
Explore in AI Chat

Overview

APPS.BENBV_WV_PRTN_RSN_PL_V is a reporting view within the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes waive participation reason configuration at the plan level, combining the underlying configuration table with descriptive lookup meanings and a business-group-filtered identifier. The object is documented in ETRM 12.2.2 and is present in 12.1.1 in the same APPS schema and form.

The view is not intended for direct customer access. Oracle's documentation explicitly marks it as Oracle Internal Use Only: the object is not supported for customer access except through standard Oracle Applications programs. Any integration or report that references it should be validated against that restriction before deployment, particularly where an upgrade path from 12.1.1 to 12.2.2 must be preserved.

Underlying Base Objects

The view depends on two documented objects:

  • BEN_WV_PRTN_RSN_PL_F — the base table holding waive participation reason records by plan, including the primary key column WV_PRTN_RSN_PL_ID, the business group key, the plan foreign key, and the effective-dating columns.
  • HR_BIS — the HR business group/security package used to restrict returned rows to the caller's business group.

No other base tables are documented. The view therefore provides a denormalized read-only projection: the coded values stored in the base table are joined to their lookup meanings, and the row set is filtered through HR_BIS so that queries return only records relevant to the current business group.

Key Columns

The column set follows the standard BEN effective-dated pattern with Who columns.

  • WV_PRTN_RSN_PL_ID — system-generated primary key; use for joins to other BEN plan-level tables.
  • PL_ID — foreign key to BEN_PL_F, identifying the plan to which the waive reason applies.
  • BUSINESS_GROUP_ID — foreign key to HR_ORGANIZATION_UNITS; the primary partition key for multi-tenant access.
  • WV_PRTN_RSN_CD and WV_PRTN_RSN_CD_M — the lookup code and its meaning against lookup type BEN_WV_PRTN_RSN.
  • DFLT_FLAG and DFLT_FLAG_M — the default indicator code and its meaning against lookup type YES_NO. DFLT_FLAG_M is the column returned when a user searches on "dflt_flag_m"; it carries the human-readable Yes/No equivalent rather than the internal code.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — the date range during which the configuration is valid; current data is filtered on SYSDATE between these bounds.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard Who audit columns.
  • _DF:WPN — a CHAR(32) placeholder column generated for the descriptive flexfield segment; it holds the flexfield context or is otherwise not intended for report use.

Common Use Cases and Queries

The view is typically queried to enumerate the waive participation reasons configured for a plan, to identify which reason is flagged as the default, or to display reason descriptions alongside codes in a concurrent program output. Because DFLT_FLAG stores a YES_NO lookup code, the DFLT_FLAG_M column is the preferred display column.

Typical pattern to list current default reasons per plan:

  • SELECT WV_PRTN_RSN_PL_ID, PL_ID, WV_PRTN_RSN_CD_M, DFLT_FLAG_M FROM APPS.BENBV_WV_PRTN_RSN_PL_V WHERE DFLT_FLAG = 'Y' AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE) AND BUSINESS_GROUP_ID = :p_bg_id ORDER BY PL_ID;

The HR_BIS package handles business group security implicitly, but explicit predicates are recommended for partitioning. Users on 12.1.1 should verify that column lengths and lookup meanings are consistent with 12.2.2 before relying on the query in a shared utility.

  • VIEW: APPS.BENBV_WV_PRTN_RSN_PL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_WV_PRTN_RSN_PL_V,  object_name:BENBV_WV_PRTN_RSN_PL_V,  status:VALID, 

  • View: BENBV_CM_DLVRY_MTHD_TYP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MTHD_TYP_V,  object_name:BENBV_CM_DLVRY_MTHD_TYP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the delivery mechanisms available to transmit compensation-related communications, for example, e-mail, voicemail, postal service and fax. ,  implementation_dba_data: APPS.BENBV_CM_DLVRY_MTHD_TYP_V , 

  • VIEW: APPS.BENBV_WV_PRTN_RSN_PL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_WV_PRTN_RSN_PL_V,  object_name:BENBV_WV_PRTN_RSN_PL_V,  status:VALID, 

  • VIEW: APPS.BENBV_CM_DLVRY_MED_TYP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MED_TYP_V,  object_name:BENBV_CM_DLVRY_MED_TYP_V,  status:VALID, 

  • VIEW: APPS.BENBV_CM_DLVRY_MTHD_TYP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MTHD_TYP_V,  object_name:BENBV_CM_DLVRY_MTHD_TYP_V,  status:VALID, 

  • VIEW: APPS.BENBV_CM_DLVRY_MTHD_TYP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MTHD_TYP_V,  object_name:BENBV_CM_DLVRY_MTHD_TYP_V,  status:VALID, 

  • VIEW: APPS.BENBV_CM_DLVRY_MED_TYP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MED_TYP_V,  object_name:BENBV_CM_DLVRY_MED_TYP_V,  status:VALID, 

  • View: BENBV_CM_DLVRY_MED_TYP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MED_TYP_V,  object_name:BENBV_CM_DLVRY_MED_TYP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the material used to create the communication. ,  implementation_dba_data: APPS.BENBV_CM_DLVRY_MED_TYP_V , 

  • View: BENBV_CM_DLVRY_MTHD_TYP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MTHD_TYP_V,  object_name:BENBV_CM_DLVRY_MTHD_TYP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the delivery mechanisms available to transmit compensation-related communications, for example, e-mail, voicemail, postal service and fax. ,  implementation_dba_data: APPS.BENBV_CM_DLVRY_MTHD_TYP_V , 

  • VIEW: APPS.BENBV_LER_CHG_PLIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PLIP_ENRT_V,  object_name:BENBV_LER_CHG_PLIP_ENRT_V,  status:VALID, 

  • View: BENBV_WV_PRTN_RSN_PL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_WV_PRTN_RSN_PL_V,  object_name:BENBV_WV_PRTN_RSN_PL_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the valid reasons a person may waive coverage in a plan as opposed to actively electing a "waive" plan. ,  implementation_dba_data: APPS.BENBV_WV_PRTN_RSN_PL_V , 

  • View: BENBV_CM_DLVRY_MED_TYP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CM_DLVRY_MED_TYP_V,  object_name:BENBV_CM_DLVRY_MED_TYP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the material used to create the communication. ,  implementation_dba_data: APPS.BENBV_CM_DLVRY_MED_TYP_V , 

  • View: BENBV_WV_PRTN_RSN_PL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_WV_PRTN_RSN_PL_V,  object_name:BENBV_WV_PRTN_RSN_PL_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the valid reasons a person may waive coverage in a plan as opposed to actively electing a "waive" plan. ,  implementation_dba_data: APPS.BENBV_WV_PRTN_RSN_PL_V , 

  • View: BENBV_LER_CHG_PL_NIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PL_NIP_ENRT_V,  object_name:BENBV_LER_CHG_PL_NIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view specifies the life events that allow an eligible person to add, change or end enrollment in a plan that is not part of a program. ,  implementation_dba_data: APPS.BENBV_LER_CHG_PL_NIP_ENRT_V , 

  • View: BENBV_LER_CHG_PL_NIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PL_NIP_ENRT_V,  object_name:BENBV_LER_CHG_PL_NIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view specifies the life events that allow an eligible person to add, change or end enrollment in a plan that is not part of a program. ,  implementation_dba_data: APPS.BENBV_LER_CHG_PL_NIP_ENRT_V , 

  • VIEW: APPS.BENBV_LER_CHG_PTIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PTIP_ENRT_V,  object_name:BENBV_LER_CHG_PTIP_ENRT_V,  status:VALID, 

  • View: BENBV_LER_CHG_OIPL_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_OIPL_ENRT_V,  object_name:BENBV_LER_CHG_OIPL_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make for an option in a plan. ,  implementation_dba_data: APPS.BENBV_LER_CHG_OIPL_ENRT_V , 

  • View: BENBV_LER_CHG_PTIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PTIP_ENRT_V,  object_name:BENBV_LER_CHG_PTIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make to a plan type in program. ,  implementation_dba_data: APPS.BENBV_LER_CHG_PTIP_ENRT_V , 

  • VIEW: APPS.BENBV_LER_CHG_PLIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PLIP_ENRT_V,  object_name:BENBV_LER_CHG_PLIP_ENRT_V,  status:VALID, 

  • View: BENBV_LER_CHG_PTIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PTIP_ENRT_V,  object_name:BENBV_LER_CHG_PTIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make to a plan type in program. ,  implementation_dba_data: APPS.BENBV_LER_CHG_PTIP_ENRT_V , 

  • View: BENBV_LER_CHG_OIPL_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_OIPL_ENRT_V,  object_name:BENBV_LER_CHG_OIPL_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make for an option in a plan. ,  implementation_dba_data: APPS.BENBV_LER_CHG_OIPL_ENRT_V , 

  • VIEW: APPS.BENBV_LER_CHG_OIPL_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_OIPL_ENRT_V,  object_name:BENBV_LER_CHG_OIPL_ENRT_V,  status:VALID, 

  • VIEW: APPS.BENBV_LER_CHG_OIPL_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_OIPL_ENRT_V,  object_name:BENBV_LER_CHG_OIPL_ENRT_V,  status:VALID, 

  • VIEW: APPS.BENBV_LER_CHG_PTIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PTIP_ENRT_V,  object_name:BENBV_LER_CHG_PTIP_ENRT_V,  status:VALID, 

  • VIEW: APPS.BENBV_LER_CHG_PL_NIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PL_NIP_ENRT_V,  object_name:BENBV_LER_CHG_PL_NIP_ENRT_V,  status:VALID, 

  • View: BENBV_LER_CHG_PLIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PLIP_ENRT_V,  object_name:BENBV_LER_CHG_PLIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make to a plan in program ,  implementation_dba_data: APPS.BENBV_LER_CHG_PLIP_ENRT_V , 

  • View: BENBV_LER_CHG_PLIP_ENRT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PLIP_ENRT_V,  object_name:BENBV_LER_CHG_PLIP_ENRT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the impact of a life event reason on the election changes a person may or may not make to a plan in program ,  implementation_dba_data: APPS.BENBV_LER_CHG_PLIP_ENRT_V , 

  • VIEW: APPS.BENBV_LER_CHG_PL_NIP_ENRT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_LER_CHG_PL_NIP_ENRT_V,  object_name:BENBV_LER_CHG_PL_NIP_ENRT_V,  status:VALID, 

  • View: BENBV_CVG_AMT_CALC_MTHD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CVG_AMT_CALC_MTHD_V,  object_name:BENBV_CVG_AMT_CALC_MTHD_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the coverage amount, or how coverage is calculated, for a plan or option in plan. ,  implementation_dba_data: APPS.BENBV_CVG_AMT_CALC_MTHD_V , 

  • View: BENBV_ENRT_BNFT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_BNFT_V,  object_name:BENBV_ENRT_BNFT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the coverage or benefit provided by the electable choices available to an eligible person as a result of a life event or open enrollment. ,  implementation_dba_data: APPS.BENBV_ENRT_BNFT_V , 

  • View: BENBV_ENRT_BNFT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_BNFT_V,  object_name:BENBV_ENRT_BNFT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the coverage or benefit provided by the electable choices available to an eligible person as a result of a life event or open enrollment. ,  implementation_dba_data: APPS.BENBV_ENRT_BNFT_V , 

  • VIEW: APPS.BENBV_ENRT_BNFT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_BNFT_V,  object_name:BENBV_ENRT_BNFT_V,  status:VALID, 

  • View: BENBV_CVG_AMT_CALC_MTHD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CVG_AMT_CALC_MTHD_V,  object_name:BENBV_CVG_AMT_CALC_MTHD_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the coverage amount, or how coverage is calculated, for a plan or option in plan. ,  implementation_dba_data: APPS.BENBV_CVG_AMT_CALC_MTHD_V , 

  • View: BENBV_OIPL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_OIPL_V,  object_name:BENBV_OIPL_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the processing characteristics of an option that is provided by a plan. ,  implementation_dba_data: APPS.BENBV_OIPL_V , 

  • View: BENBV_OIPL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_OIPL_V,  object_name:BENBV_OIPL_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the processing characteristics of an option that is provided by a plan. ,  implementation_dba_data: APPS.BENBV_OIPL_V , 

  • VIEW: APPS.BENBV_CVG_AMT_CALC_MTHD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CVG_AMT_CALC_MTHD_V,  object_name:BENBV_CVG_AMT_CALC_MTHD_V,  status:VALID, 

  • VIEW: APPS.BENBV_ENRT_BNFT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_BNFT_V,  object_name:BENBV_ENRT_BNFT_V,  status:VALID, 

  • VIEW: APPS.BENBV_CVG_AMT_CALC_MTHD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_CVG_AMT_CALC_MTHD_V,  object_name:BENBV_CVG_AMT_CALC_MTHD_V,  status:VALID, 

  • View: BENBV_PLIP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_PLIP_V,  object_name:BENBV_PLIP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies and specifies processing characteristics of a plan assigned to a program. ,  implementation_dba_data: APPS.BENBV_PLIP_V , 

  • View: BENBV_ENRT_RT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_RT_V,  object_name:BENBV_ENRT_RT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the rates calculated for a person for a plan or option in plan. It also identifies flexible credit values and imputed income values. ,  implementation_dba_data: APPS.BENBV_ENRT_RT_V , 

  • View: BENBV_ELIG_PER_ELCTBL_CHC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ELIG_PER_ELCTBL_CHC_V,  object_name:BENBV_ELIG_PER_ELCTBL_CHC_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the plans or options in plan a person may elect as the result of a life event. ,  implementation_dba_data: APPS.BENBV_ELIG_PER_ELCTBL_CHC_V , 

  • View: BENBV_ELIG_PER_ELCTBL_CHC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ELIG_PER_ELCTBL_CHC_V,  object_name:BENBV_ELIG_PER_ELCTBL_CHC_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the plans or options in plan a person may elect as the result of a life event. ,  implementation_dba_data: APPS.BENBV_ELIG_PER_ELCTBL_CHC_V , 

  • VIEW: APPS.BENBV_ACTY_BASE_RT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ACTY_BASE_RT_V,  object_name:BENBV_ACTY_BASE_RT_V,  status:VALID, 

  • VIEW: APPS.BENBV_ACTY_BASE_RT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ACTY_BASE_RT_V,  object_name:BENBV_ACTY_BASE_RT_V,  status:VALID, 

  • View: BENBV_ENRT_RT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_RT_V,  object_name:BENBV_ENRT_RT_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies the rates calculated for a person for a plan or option in plan. It also identifies flexible credit values and imputed income values. ,  implementation_dba_data: APPS.BENBV_ENRT_RT_V , 

  • View: BENBV_PLIP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_PLIP_V,  object_name:BENBV_PLIP_V,  status:VALID,  product: BEN - Advanced Benefits ,  description: This view identifies and specifies processing characteristics of a plan assigned to a program. ,  implementation_dba_data: APPS.BENBV_PLIP_V , 

  • VIEW: APPS.BENBV_OIPL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_OIPL_V,  object_name:BENBV_OIPL_V,  status:VALID, 

  • VIEW: APPS.BENBV_OIPL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_OIPL_V,  object_name:BENBV_OIPL_V,  status:VALID, 

  • VIEW: APPS.BENBV_ENRT_RT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_RT_V,  object_name:BENBV_ENRT_RT_V,  status:VALID, 

  • VIEW: APPS.BENBV_ENRT_RT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:BEN.BENBV_ENRT_RT_V,  object_name:BENBV_ENRT_RT_V,  status:VALID,