View: BEN_ELIG_DPNT_CVRD_OTHR_PL

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ELIG_DPNT_CVRD_OTHR_PL

View Text

SELECT EDP.ELIG_DPNT_CVRD_OTHR_PL_ID
, EDP.EFFECTIVE_START_DATE
, EDP.EFFECTIVE_END_DATE
, EDP.ORDR_NUM
, EDP.EXCLD_FLAG
, EDP.CVG_DET_DT_CD
, EDP.BUSINESS_GROUP_ID
, EDP.ELIGY_PRFL_ID
, EDP.PL_ID
, EDP.EDP_ATTRIBUTE_CATEGORY
, EDP.EDP_ATTRIBUTE1
, EDP.EDP_ATTRIBUTE2
, EDP.EDP_ATTRIBUTE3
, EDP.EDP_ATTRIBUTE4
, EDP.EDP_ATTRIBUTE5
, EDP.EDP_ATTRIBUTE6
, EDP.EDP_ATTRIBUTE7
, EDP.EDP_ATTRIBUTE8
, EDP.EDP_ATTRIBUTE9
, EDP.EDP_ATTRIBUTE10
, EDP.EDP_ATTRIBUTE11
, EDP.EDP_ATTRIBUTE12
, EDP.EDP_ATTRIBUTE13
, EDP.EDP_ATTRIBUTE14
, EDP.EDP_ATTRIBUTE15
, EDP.EDP_ATTRIBUTE16
, EDP.EDP_ATTRIBUTE17
, EDP.EDP_ATTRIBUTE18
, EDP.EDP_ATTRIBUTE19
, EDP.EDP_ATTRIBUTE20
, EDP.EDP_ATTRIBUTE21
, EDP.EDP_ATTRIBUTE22
, EDP.EDP_ATTRIBUTE23
, EDP.EDP_ATTRIBUTE24
, EDP.EDP_ATTRIBUTE25
, EDP.EDP_ATTRIBUTE26
, EDP.EDP_ATTRIBUTE27
, EDP.EDP_ATTRIBUTE28
, EDP.EDP_ATTRIBUTE29
, EDP.EDP_ATTRIBUTE30
, EDP.LAST_UPDATE_DATE
, EDP.LAST_UPDATED_BY
, EDP.LAST_UPDATE_LOGIN
, EDP.CREATED_BY
, EDP.CREATION_DATE
, EDP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP
WHERE EDP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns