VIEW: APPS.BEN_ENRT_ELIG_DPNT_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)