Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_CVRD_DPNT_X |
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