Product: | BEN - Advanced Benefits |
---|---|
Description: | This view identifies the applicable disabled statuses which contact must have, to be eligible for a participant to designate a him or her for coverage |
Implementation/DBA Data: | APPS.BENBV_ELIG_DSBLD_STAT_CVG_V |
SELECT EDC.EFFECTIVE_START_DATE
, EDC.EFFECTIVE_END_DATE
, EDC.CVG_STRT_RL
, EDC.CVG_THRU_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_DSBLD_STAT_CVG_F:EDC'
, /* CODES */ EDC.DSBLD_CD
, HR_BIS.BIS_DECODE_LOOKUP('REGISTERED_DISABLED'
, EDC.DSBLD_CD)
, EDC.CVG_STRT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_START'
, EDC.CVG_STRT_CD)
, EDC.CVG_THRU_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_DPNT_CVG_END'
, EDC.CVG_THRU_CD)
, /* ID COLUMNS */ EDC.ELIG_DSBLD_STAT_CVG_ID
, EDC.BUSINESS_GROUP_ID
, EDC.DPNT_CVG_ELIGY_PRFL_ID
, /* WHO COLUMNS */ EDC.LAST_UPDATE_DATE
, EDC.LAST_UPDATED_BY
, EDC.CREATED_BY
, EDC.CREATION_DATE
FROM BEN_ELIG_DSBLD_STAT_CVG_F EDC
WHERE EDC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EDC.BUSINESS_GROUP_ID) WITH READ ONLY