VIEW: APPS.BEN_ELIG_CVRD_DPNT_X

Source

View Text - Preformatted

SELECT PDP.ELIG_CVRD_DPNT_ID , PDP.EFFECTIVE_START_DATE , PDP.EFFECTIVE_END_DATE , PDP.BUSINESS_GROUP_ID , PDP.ELIG_PER_ELCTBL_CHC_ID , PDP.PRTT_ENRT_RSLT_ID , PDP.DPNT_PERSON_ID , PDP.CVG_STRT_DT , PDP.CVG_THRU_DT , PDP.CVG_PNDG_FLAG , PDP.PDP_ATTRIBUTE_CATEGORY , PDP.PDP_ATTRIBUTE1 , PDP.PDP_ATTRIBUTE2 , PDP.PDP_ATTRIBUTE3 , PDP.PDP_ATTRIBUTE4 , PDP.PDP_ATTRIBUTE5 , PDP.PDP_ATTRIBUTE6 , PDP.PDP_ATTRIBUTE7 , PDP.PDP_ATTRIBUTE8 , PDP.PDP_ATTRIBUTE9 , PDP.PDP_ATTRIBUTE10 , PDP.PDP_ATTRIBUTE11 , PDP.PDP_ATTRIBUTE12 , PDP.PDP_ATTRIBUTE13 , PDP.PDP_ATTRIBUTE14 , PDP.PDP_ATTRIBUTE15 , PDP.PDP_ATTRIBUTE16 , PDP.PDP_ATTRIBUTE17 , PDP.PDP_ATTRIBUTE18 , PDP.PDP_ATTRIBUTE19 , PDP.PDP_ATTRIBUTE20 , PDP.PDP_ATTRIBUTE21 , PDP.PDP_ATTRIBUTE22 , PDP.PDP_ATTRIBUTE23 , PDP.PDP_ATTRIBUTE24 , PDP.PDP_ATTRIBUTE25 , PDP.PDP_ATTRIBUTE26 , PDP.PDP_ATTRIBUTE27 , PDP.PDP_ATTRIBUTE28 , PDP.PDP_ATTRIBUTE29 , PDP.PDP_ATTRIBUTE30 , PDP.LAST_UPDATE_DATE , PDP.LAST_UPDATED_BY , PDP.LAST_UPDATE_LOGIN , PDP.CREATED_BY , PDP.CREATION_DATE , PDP.REQUEST_ID , PDP.PROGRAM_APPLICATION_ID , PDP.PROGRAM_ID , PDP.PROGRAM_UPDATE_DATE , PDP.OBJECT_VERSION_NUMBER , PDP.OVRDN_FLAG , PDP.PER_IN_LER_ID , PDP.OVRDN_THRU_DT FROM BEN_ELIG_CVRD_DPNT_F PDP WHERE TRUNC(SYSDATE) BETWEEN PDP.EFFECTIVE_START_DATE AND PDP.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PDP.ELIG_CVRD_DPNT_ID
, PDP.EFFECTIVE_START_DATE
, PDP.EFFECTIVE_END_DATE
, PDP.BUSINESS_GROUP_ID
, PDP.ELIG_PER_ELCTBL_CHC_ID
, PDP.PRTT_ENRT_RSLT_ID
, PDP.DPNT_PERSON_ID
, PDP.CVG_STRT_DT
, PDP.CVG_THRU_DT
, PDP.CVG_PNDG_FLAG
, PDP.PDP_ATTRIBUTE_CATEGORY
, PDP.PDP_ATTRIBUTE1
, PDP.PDP_ATTRIBUTE2
, PDP.PDP_ATTRIBUTE3
, PDP.PDP_ATTRIBUTE4
, PDP.PDP_ATTRIBUTE5
, PDP.PDP_ATTRIBUTE6
, PDP.PDP_ATTRIBUTE7
, PDP.PDP_ATTRIBUTE8
, PDP.PDP_ATTRIBUTE9
, PDP.PDP_ATTRIBUTE10
, PDP.PDP_ATTRIBUTE11
, PDP.PDP_ATTRIBUTE12
, PDP.PDP_ATTRIBUTE13
, PDP.PDP_ATTRIBUTE14
, PDP.PDP_ATTRIBUTE15
, PDP.PDP_ATTRIBUTE16
, PDP.PDP_ATTRIBUTE17
, PDP.PDP_ATTRIBUTE18
, PDP.PDP_ATTRIBUTE19
, PDP.PDP_ATTRIBUTE20
, PDP.PDP_ATTRIBUTE21
, PDP.PDP_ATTRIBUTE22
, PDP.PDP_ATTRIBUTE23
, PDP.PDP_ATTRIBUTE24
, PDP.PDP_ATTRIBUTE25
, PDP.PDP_ATTRIBUTE26
, PDP.PDP_ATTRIBUTE27
, PDP.PDP_ATTRIBUTE28
, PDP.PDP_ATTRIBUTE29
, PDP.PDP_ATTRIBUTE30
, PDP.LAST_UPDATE_DATE
, PDP.LAST_UPDATED_BY
, PDP.LAST_UPDATE_LOGIN
, PDP.CREATED_BY
, PDP.CREATION_DATE
, PDP.REQUEST_ID
, PDP.PROGRAM_APPLICATION_ID
, PDP.PROGRAM_ID
, PDP.PROGRAM_UPDATE_DATE
, PDP.OBJECT_VERSION_NUMBER
, PDP.OVRDN_FLAG
, PDP.PER_IN_LER_ID
, PDP.OVRDN_THRU_DT
FROM BEN_ELIG_CVRD_DPNT_F PDP
WHERE TRUNC(SYSDATE) BETWEEN PDP.EFFECTIVE_START_DATE
AND PDP.EFFECTIVE_END_DATE