VIEW: APPS.BEN_LER_CHG_PGM_ENRT

Source

View Text - Preformatted

SELECT lge.LER_CHG_PGM_ENRT_ID ,lge.EFFECTIVE_START_DATE ,lge.EFFECTIVE_END_DATE ,lge.AUTO_ENRT_MTHD_RL ,lge.CRNT_ENRT_PRCLDS_CHG_FLAG ,lge.BUSINESS_GROUP_ID ,lge.PGM_ID ,lge.LER_ID ,lge.DFLT_ENRT_CD ,lge.DFLT_ENRT_RL ,lge.ENRT_CD ,lge.ENRT_MTHD_CD ,lge.ENRT_RL ,lge.STL_ELIG_CANT_CHG_FLAG ,lge.LGE_ATTRIBUTE_CATEGORY ,lge.LGE_ATTRIBUTE1 ,lge.LGE_ATTRIBUTE2 ,lge.LGE_ATTRIBUTE3 ,lge.LGE_ATTRIBUTE4 ,lge.LGE_ATTRIBUTE5 ,lge.LGE_ATTRIBUTE6 ,lge.LGE_ATTRIBUTE7 ,lge.LGE_ATTRIBUTE8 ,lge.LGE_ATTRIBUTE9 ,lge.LGE_ATTRIBUTE10 ,lge.LGE_ATTRIBUTE11 ,lge.LGE_ATTRIBUTE12 ,lge.LGE_ATTRIBUTE13 ,lge.LGE_ATTRIBUTE14 ,lge.LGE_ATTRIBUTE15 ,lge.LGE_ATTRIBUTE16 ,lge.LGE_ATTRIBUTE17 ,lge.LGE_ATTRIBUTE18 ,lge.LGE_ATTRIBUTE19 ,lge.LGE_ATTRIBUTE20 ,lge.LGE_ATTRIBUTE21 ,lge.LGE_ATTRIBUTE22 ,lge.LGE_ATTRIBUTE23 ,lge.LGE_ATTRIBUTE24 ,lge.LGE_ATTRIBUTE25 ,lge.LGE_ATTRIBUTE26 ,lge.LGE_ATTRIBUTE27 ,lge.LGE_ATTRIBUTE28 ,lge.LGE_ATTRIBUTE29 ,lge.LGE_ATTRIBUTE30 ,lge.LAST_UPDATE_DATE ,lge.LAST_UPDATED_BY ,lge.LAST_UPDATE_LOGIN ,lge.CREATED_BY ,lge.CREATION_DATE ,lge.OBJECT_VERSION_NUMBER from BEN_LER_CHG_PGM_ENRT_F lge WHERE lge.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and lge.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT LGE.LER_CHG_PGM_ENRT_ID
, LGE.EFFECTIVE_START_DATE
, LGE.EFFECTIVE_END_DATE
, LGE.AUTO_ENRT_MTHD_RL
, LGE.CRNT_ENRT_PRCLDS_CHG_FLAG
, LGE.BUSINESS_GROUP_ID
, LGE.PGM_ID
, LGE.LER_ID
, LGE.DFLT_ENRT_CD
, LGE.DFLT_ENRT_RL
, LGE.ENRT_CD
, LGE.ENRT_MTHD_CD
, LGE.ENRT_RL
, LGE.STL_ELIG_CANT_CHG_FLAG
, LGE.LGE_ATTRIBUTE_CATEGORY
, LGE.LGE_ATTRIBUTE1
, LGE.LGE_ATTRIBUTE2
, LGE.LGE_ATTRIBUTE3
, LGE.LGE_ATTRIBUTE4
, LGE.LGE_ATTRIBUTE5
, LGE.LGE_ATTRIBUTE6
, LGE.LGE_ATTRIBUTE7
, LGE.LGE_ATTRIBUTE8
, LGE.LGE_ATTRIBUTE9
, LGE.LGE_ATTRIBUTE10
, LGE.LGE_ATTRIBUTE11
, LGE.LGE_ATTRIBUTE12
, LGE.LGE_ATTRIBUTE13
, LGE.LGE_ATTRIBUTE14
, LGE.LGE_ATTRIBUTE15
, LGE.LGE_ATTRIBUTE16
, LGE.LGE_ATTRIBUTE17
, LGE.LGE_ATTRIBUTE18
, LGE.LGE_ATTRIBUTE19
, LGE.LGE_ATTRIBUTE20
, LGE.LGE_ATTRIBUTE21
, LGE.LGE_ATTRIBUTE22
, LGE.LGE_ATTRIBUTE23
, LGE.LGE_ATTRIBUTE24
, LGE.LGE_ATTRIBUTE25
, LGE.LGE_ATTRIBUTE26
, LGE.LGE_ATTRIBUTE27
, LGE.LGE_ATTRIBUTE28
, LGE.LGE_ATTRIBUTE29
, LGE.LGE_ATTRIBUTE30
, LGE.LAST_UPDATE_DATE
, LGE.LAST_UPDATED_BY
, LGE.LAST_UPDATE_LOGIN
, LGE.CREATED_BY
, LGE.CREATION_DATE
, LGE.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_PGM_ENRT_F LGE
WHERE LGE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LGE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))