VIEW: APPS.BENBV_ELIG_DSBLD_STAT_CVG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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