Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_ENRT_ELIG_DPNT_V |
SELECT EGD.ELIG_DPNT_ID
, EGD.ELIG_PER_ELCTBL_CHC_ID
, PDP.ELIG_CVRD_DPNT_ID
, PDP.EFFECTIVE_START_DATE
, PDP.EFFECTIVE_END_DATE
, EGD.BUSINESS_GROUP_ID
, PDP.PRTT_ENRT_RSLT_ID
, EGD.DPNT_PERSON_ID
, PDP.CVG_STRT_DT
, PDP.CVG_THRU_DT
, NVL(PDP.CVG_PNDG_FLAG
, 'N')
, 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
, NVL(PDP.OVRDN_FLAG
, 'N')
, EGD.PER_IN_LER_ID
, PDP.OVRDN_THRU_DT
FROM BEN_ELIG_CVRD_DPNT_F PDP
, BEN_ELIG_DPNT EGD
, FND_SESSIONS SE
WHERE EGD.ELIG_CVRD_DPNT_ID = PDP.ELIG_CVRD_DPNT_ID (+)
AND SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN NVL(PDP.EFFECTIVE_START_DATE
, SE.EFFECTIVE_DATE)
AND NVL(PDP.EFFECTIVE_END_DATE
, SE.EFFECTIVE_DATE)