VIEW: APPS.BEN_ELIG_DPNT_CVRD_OTHR_PGM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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