View: BEN_ELIG_DPNT_CVRD_OTHR_PGM_V

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

View Text

SELECT EDG.ROWID ROW_ID
, EDG.ELIG_DPNT_CVRD_OTHR_PGM_ID
, EDG.EFFECTIVE_START_DATE
, EDG.EFFECTIVE_END_DATE
, EDG.EXCLD_FLAG
, EDG.ONLY_PLS_SUBJ_COBRA_FLAG
, EDG.ENRL_DET_DT_CD
, EDG.ORDR_NUM
, EDG.PGM_ID
, EDG.ELIGY_PRFL_ID
, EDG.BUSINESS_GROUP_ID
, EDG.EDG_ATTRIBUTE_CATEGORY
, EDG.EDG_ATTRIBUTE1
, EDG.EDG_ATTRIBUTE2
, EDG.EDG_ATTRIBUTE3
, EDG.EDG_ATTRIBUTE4
, EDG.EDG_ATTRIBUTE5
, EDG.EDG_ATTRIBUTE6
, EDG.EDG_ATTRIBUTE7
, EDG.EDG_ATTRIBUTE8
, EDG.EDG_ATTRIBUTE9
, EDG.EDG_ATTRIBUTE10
, EDG.EDG_ATTRIBUTE11
, EDG.EDG_ATTRIBUTE12
, EDG.EDG_ATTRIBUTE13
, EDG.EDG_ATTRIBUTE14
, EDG.EDG_ATTRIBUTE15
, EDG.EDG_ATTRIBUTE16
, EDG.EDG_ATTRIBUTE17
, EDG.EDG_ATTRIBUTE18
, EDG.EDG_ATTRIBUTE19
, EDG.EDG_ATTRIBUTE20
, EDG.EDG_ATTRIBUTE21
, EDG.EDG_ATTRIBUTE22
, EDG.EDG_ATTRIBUTE23
, EDG.EDG_ATTRIBUTE24
, EDG.EDG_ATTRIBUTE25
, EDG.EDG_ATTRIBUTE26
, EDG.EDG_ATTRIBUTE27
, EDG.EDG_ATTRIBUTE28
, EDG.EDG_ATTRIBUTE29
, EDG.EDG_ATTRIBUTE30
, EDG.LAST_UPDATE_DATE
, EDG.LAST_UPDATED_BY
, EDG.LAST_UPDATE_LOGIN
, EDG.CREATED_BY
, EDG.CREATION_DATE
, EDG.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PGM_F EDG
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EDG.EFFECTIVE_START_DATE
AND EDG.EFFECTIVE_END_DATE

Columns