VIEW: APPS.BEN_ELIG_ENRLD_ANTHR_PTIP_V

Source

View Text - Preformatted

SELECT eet.ROWID ROW_ID, eet.ELIG_ENRLD_ANTHR_PTIP_ID ,eet.EFFECTIVE_START_DATE ,eet.EFFECTIVE_END_DATE ,eet.ORDR_NUM ,eet.EXCLD_FLAG ,eet.ENRL_DET_DT_CD ,eet.ONLY_PLS_SUBJ_COBRA_FLAG ,eet.PTIP_ID ,eet.ELIGY_PRFL_ID ,eet.BUSINESS_GROUP_ID ,eet.EET_ATTRIBUTE_CATEGORY ,eet.EET_ATTRIBUTE1 ,eet.EET_ATTRIBUTE2 ,eet.EET_ATTRIBUTE3 ,eet.EET_ATTRIBUTE4 ,eet.EET_ATTRIBUTE5 ,eet.EET_ATTRIBUTE6 ,eet.EET_ATTRIBUTE7 ,eet.EET_ATTRIBUTE8 ,eet.EET_ATTRIBUTE9 ,eet.EET_ATTRIBUTE10 ,eet.EET_ATTRIBUTE11 ,eet.EET_ATTRIBUTE12 ,eet.EET_ATTRIBUTE13 ,eet.EET_ATTRIBUTE14 ,eet.EET_ATTRIBUTE15 ,eet.EET_ATTRIBUTE16 ,eet.EET_ATTRIBUTE17 ,eet.EET_ATTRIBUTE18 ,eet.EET_ATTRIBUTE19 ,eet.EET_ATTRIBUTE20 ,eet.EET_ATTRIBUTE21 ,eet.EET_ATTRIBUTE22 ,eet.EET_ATTRIBUTE23 ,eet.EET_ATTRIBUTE24 ,eet.EET_ATTRIBUTE25 ,eet.EET_ATTRIBUTE26 ,eet.EET_ATTRIBUTE27 ,eet.EET_ATTRIBUTE28 ,eet.EET_ATTRIBUTE29 ,eet.EET_ATTRIBUTE30 ,eet.LAST_UPDATE_DATE ,eet.LAST_UPDATED_BY ,eet.LAST_UPDATE_LOGIN ,eet.CREATED_BY ,eet.CREATION_DATE ,eet.OBJECT_VERSION_NUMBER from BEN_ELIG_ENRLD_ANTHR_PTIP_F eet, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between eet.effective_start_date and eet.effective_end_date

View Text - HTML Formatted

SELECT EET.ROWID ROW_ID
, EET.ELIG_ENRLD_ANTHR_PTIP_ID
, EET.EFFECTIVE_START_DATE
, EET.EFFECTIVE_END_DATE
, EET.ORDR_NUM
, EET.EXCLD_FLAG
, EET.ENRL_DET_DT_CD
, EET.ONLY_PLS_SUBJ_COBRA_FLAG
, EET.PTIP_ID
, EET.ELIGY_PRFL_ID
, EET.BUSINESS_GROUP_ID
, EET.EET_ATTRIBUTE_CATEGORY
, EET.EET_ATTRIBUTE1
, EET.EET_ATTRIBUTE2
, EET.EET_ATTRIBUTE3
, EET.EET_ATTRIBUTE4
, EET.EET_ATTRIBUTE5
, EET.EET_ATTRIBUTE6
, EET.EET_ATTRIBUTE7
, EET.EET_ATTRIBUTE8
, EET.EET_ATTRIBUTE9
, EET.EET_ATTRIBUTE10
, EET.EET_ATTRIBUTE11
, EET.EET_ATTRIBUTE12
, EET.EET_ATTRIBUTE13
, EET.EET_ATTRIBUTE14
, EET.EET_ATTRIBUTE15
, EET.EET_ATTRIBUTE16
, EET.EET_ATTRIBUTE17
, EET.EET_ATTRIBUTE18
, EET.EET_ATTRIBUTE19
, EET.EET_ATTRIBUTE20
, EET.EET_ATTRIBUTE21
, EET.EET_ATTRIBUTE22
, EET.EET_ATTRIBUTE23
, EET.EET_ATTRIBUTE24
, EET.EET_ATTRIBUTE25
, EET.EET_ATTRIBUTE26
, EET.EET_ATTRIBUTE27
, EET.EET_ATTRIBUTE28
, EET.EET_ATTRIBUTE29
, EET.EET_ATTRIBUTE30
, EET.LAST_UPDATE_DATE
, EET.LAST_UPDATED_BY
, EET.LAST_UPDATE_LOGIN
, EET.CREATED_BY
, EET.CREATION_DATE
, EET.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_ENRLD_ANTHR_PTIP_F EET
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EET.EFFECTIVE_START_DATE
AND EET.EFFECTIVE_END_DATE