VIEW: APPS.BENBV_ELIG_CVRD_DPNT_V

Source

View Text - Preformatted

SELECT PDP.EFFECTIVE_START_DATE, PDP.EFFECTIVE_END_DATE, PDP.PROGRAM_UPDATE_DATE, PDP.CVG_STRT_DT, PDP.CVG_THRU_DT, PDP.OVRDN_THRU_DT, /* descriptive flexfield */ '_DF:BEN:BEN_ELIG_CVRD_DPNT_F:PDP', PDP.CVG_PNDG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PDP.CVG_PNDG_FLAG), PDP.OVRDN_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PDP.OVRDN_FLAG), /* id columns */ PDP.ELIG_CVRD_DPNT_ID, PDP.DPNT_PERSON_ID, PDP.PER_IN_LER_ID, PDP.BUSINESS_GROUP_ID, PDP.REQUEST_ID, PDP.PROGRAM_APPLICATION_ID, PDP.PROGRAM_ID, PDP.PRTT_ENRT_RSLT_ID, PDP.ELIG_PER_ELCTBL_CHC_ID, /* who columns */ PDP.LAST_UPDATE_DATE, PDP.LAST_UPDATED_BY, PDP.CREATED_BY, PDP.CREATION_DATE FROM BEN_ELIG_CVRD_DPNT_F PDP WHERE PDP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PDP.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PDP.EFFECTIVE_START_DATE
, PDP.EFFECTIVE_END_DATE
, PDP.PROGRAM_UPDATE_DATE
, PDP.CVG_STRT_DT
, PDP.CVG_THRU_DT
, PDP.OVRDN_THRU_DT
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_ELIG_CVRD_DPNT_F:PDP'
, PDP.CVG_PNDG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDP.CVG_PNDG_FLAG)
, PDP.OVRDN_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDP.OVRDN_FLAG)
, /* ID COLUMNS */ PDP.ELIG_CVRD_DPNT_ID
, PDP.DPNT_PERSON_ID
, PDP.PER_IN_LER_ID
, PDP.BUSINESS_GROUP_ID
, PDP.REQUEST_ID
, PDP.PROGRAM_APPLICATION_ID
, PDP.PROGRAM_ID
, PDP.PRTT_ENRT_RSLT_ID
, PDP.ELIG_PER_ELCTBL_CHC_ID
, /* WHO COLUMNS */ PDP.LAST_UPDATE_DATE
, PDP.LAST_UPDATED_BY
, PDP.CREATED_BY
, PDP.CREATION_DATE
FROM BEN_ELIG_CVRD_DPNT_F PDP
WHERE PDP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDP.BUSINESS_GROUP_ID) WITH READ ONLY