VIEW: APPS.BEN_ELIG_DPNT_CVRD_OTHR_PTIP

Source

View Text - Preformatted

SELECT edt.ELIG_DPNT_CVRD_OTHR_PTIP_ID ,edt.EFFECTIVE_START_DATE ,edt.EFFECTIVE_END_DATE ,edt.EXCLD_FLAG ,edt.ORDR_NUM ,edt.ENRL_DET_DT_CD ,edt.ONLY_PLS_SUBJ_COBRA_FLAG ,edt.PTIP_ID ,edt.ELIGY_PRFL_ID ,edt.BUSINESS_GROUP_ID ,edt.EDT_ATTRIBUTE_CATEGORY ,edt.EDT_ATTRIBUTE1 ,edt.EDT_ATTRIBUTE2 ,edt.EDT_ATTRIBUTE3 ,edt.EDT_ATTRIBUTE4 ,edt.EDT_ATTRIBUTE5 ,edt.EDT_ATTRIBUTE6 ,edt.EDT_ATTRIBUTE7 ,edt.EDT_ATTRIBUTE8 ,edt.EDT_ATTRIBUTE9 ,edt.EDT_ATTRIBUTE10 ,edt.EDT_ATTRIBUTE11 ,edt.EDT_ATTRIBUTE12 ,edt.EDT_ATTRIBUTE13 ,edt.EDT_ATTRIBUTE14 ,edt.EDT_ATTRIBUTE15 ,edt.EDT_ATTRIBUTE16 ,edt.EDT_ATTRIBUTE17 ,edt.EDT_ATTRIBUTE18 ,edt.EDT_ATTRIBUTE19 ,edt.EDT_ATTRIBUTE20 ,edt.EDT_ATTRIBUTE21 ,edt.EDT_ATTRIBUTE22 ,edt.EDT_ATTRIBUTE23 ,edt.EDT_ATTRIBUTE24 ,edt.EDT_ATTRIBUTE25 ,edt.EDT_ATTRIBUTE26 ,edt.EDT_ATTRIBUTE27 ,edt.EDT_ATTRIBUTE28 ,edt.EDT_ATTRIBUTE29 ,edt.EDT_ATTRIBUTE30 ,edt.LAST_UPDATE_DATE ,edt.LAST_UPDATED_BY ,edt.LAST_UPDATE_LOGIN ,edt.CREATED_BY ,edt.CREATION_DATE ,edt.OBJECT_VERSION_NUMBER from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F edt WHERE edt.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and edt.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT EDT.ELIG_DPNT_CVRD_OTHR_PTIP_ID
, EDT.EFFECTIVE_START_DATE
, EDT.EFFECTIVE_END_DATE
, EDT.EXCLD_FLAG
, EDT.ORDR_NUM
, EDT.ENRL_DET_DT_CD
, EDT.ONLY_PLS_SUBJ_COBRA_FLAG
, EDT.PTIP_ID
, EDT.ELIGY_PRFL_ID
, EDT.BUSINESS_GROUP_ID
, EDT.EDT_ATTRIBUTE_CATEGORY
, EDT.EDT_ATTRIBUTE1
, EDT.EDT_ATTRIBUTE2
, EDT.EDT_ATTRIBUTE3
, EDT.EDT_ATTRIBUTE4
, EDT.EDT_ATTRIBUTE5
, EDT.EDT_ATTRIBUTE6
, EDT.EDT_ATTRIBUTE7
, EDT.EDT_ATTRIBUTE8
, EDT.EDT_ATTRIBUTE9
, EDT.EDT_ATTRIBUTE10
, EDT.EDT_ATTRIBUTE11
, EDT.EDT_ATTRIBUTE12
, EDT.EDT_ATTRIBUTE13
, EDT.EDT_ATTRIBUTE14
, EDT.EDT_ATTRIBUTE15
, EDT.EDT_ATTRIBUTE16
, EDT.EDT_ATTRIBUTE17
, EDT.EDT_ATTRIBUTE18
, EDT.EDT_ATTRIBUTE19
, EDT.EDT_ATTRIBUTE20
, EDT.EDT_ATTRIBUTE21
, EDT.EDT_ATTRIBUTE22
, EDT.EDT_ATTRIBUTE23
, EDT.EDT_ATTRIBUTE24
, EDT.EDT_ATTRIBUTE25
, EDT.EDT_ATTRIBUTE26
, EDT.EDT_ATTRIBUTE27
, EDT.EDT_ATTRIBUTE28
, EDT.EDT_ATTRIBUTE29
, EDT.EDT_ATTRIBUTE30
, EDT.LAST_UPDATE_DATE
, EDT.LAST_UPDATED_BY
, EDT.LAST_UPDATE_LOGIN
, EDT.CREATED_BY
, EDT.CREATION_DATE
, EDT.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F EDT
WHERE EDT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EDT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))