View: BENBV_ENRT_PERD_FOR_PL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies the plans in program for which an enrollment period has been defined. Enrollment periods may be specified for programs or plans not in program.
Implementation/DBA Data:	APPS.BENBV_ENRT_PERD_FOR_PL_V

View Text

SELECT ERP.EFFECTIVE_START_DATE
, ERP.EFFECTIVE_END_DATE
, ERP.ENRT_CVG_STRT_DT_RL
, ERP.ENRT_CVG_END_DT_RL
, ERP.RT_STRT_DT_RL
, ERP.RT_END_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ENRT_PERD_FOR_PL_F:ERP'
, /* CODES */ ERP.ENRT_CVG_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_STRT'
, ERP.ENRT_CVG_STRT_DT_CD)
, ERP.ENRT_CVG_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_CVG_END'
, ERP.ENRT_CVG_END_DT_CD)
, ERP.RT_STRT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_STRT'
, ERP.RT_STRT_DT_CD)
, ERP.RT_END_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_END'
, ERP.RT_END_DT_CD)
, /* ID COLUMNS */ ERP.ENRT_PERD_FOR_PL_ID
, ERP.BUSINESS_GROUP_ID
, ERP.PL_ID
, ERP.ENRT_PERD_ID
, ERP.LEE_RSN_ID
, /* WHO COLUMNS */ ERP.LAST_UPDATE_DATE
, ERP.LAST_UPDATED_BY
, ERP.CREATED_BY
, ERP.CREATION_DATE
FROM BEN_ENRT_PERD_FOR_PL_F ERP
WHERE ERP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ERP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns