VIEW: APPS.BEN_LER_ENRT_CTFN

Source

View Text - Preformatted

SELECT lnc.LER_ENRT_CTFN_ID ,lnc.EFFECTIVE_START_DATE ,lnc.EFFECTIVE_END_DATE ,lnc.RQD_FLAG ,lnc.ENRT_CTFN_TYP_CD ,lnc.CTFN_RQD_WHEN_RL ,lnc.LER_RQRS_ENRT_CTFN_ID ,lnc.BUSINESS_GROUP_ID ,lnc.LNC_ATTRIBUTE_CATEGORY ,lnc.LNC_ATTRIBUTE1 ,lnc.LNC_ATTRIBUTE2 ,lnc.LNC_ATTRIBUTE3 ,lnc.LNC_ATTRIBUTE4 ,lnc.LNC_ATTRIBUTE5 ,lnc.LNC_ATTRIBUTE6 ,lnc.LNC_ATTRIBUTE7 ,lnc.LNC_ATTRIBUTE8 ,lnc.LNC_ATTRIBUTE9 ,lnc.LNC_ATTRIBUTE10 ,lnc.LNC_ATTRIBUTE11 ,lnc.LNC_ATTRIBUTE12 ,lnc.LNC_ATTRIBUTE13 ,lnc.LNC_ATTRIBUTE14 ,lnc.LNC_ATTRIBUTE15 ,lnc.LNC_ATTRIBUTE16 ,lnc.LNC_ATTRIBUTE17 ,lnc.LNC_ATTRIBUTE18 ,lnc.LNC_ATTRIBUTE19 ,lnc.LNC_ATTRIBUTE20 ,lnc.LNC_ATTRIBUTE21 ,lnc.LNC_ATTRIBUTE22 ,lnc.LNC_ATTRIBUTE23 ,lnc.LNC_ATTRIBUTE24 ,lnc.LNC_ATTRIBUTE25 ,lnc.LNC_ATTRIBUTE26 ,lnc.LNC_ATTRIBUTE27 ,lnc.LNC_ATTRIBUTE28 ,lnc.LNC_ATTRIBUTE29 ,lnc.LNC_ATTRIBUTE30 ,lnc.LAST_UPDATE_DATE ,lnc.LAST_UPDATED_BY ,lnc.LAST_UPDATE_LOGIN ,lnc.CREATED_BY ,lnc.CREATION_DATE ,lnc.OBJECT_VERSION_NUMBER from BEN_LER_ENRT_CTFN_F lnc WHERE lnc.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and lnc.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT LNC.LER_ENRT_CTFN_ID
, LNC.EFFECTIVE_START_DATE
, LNC.EFFECTIVE_END_DATE
, LNC.RQD_FLAG
, LNC.ENRT_CTFN_TYP_CD
, LNC.CTFN_RQD_WHEN_RL
, LNC.LER_RQRS_ENRT_CTFN_ID
, LNC.BUSINESS_GROUP_ID
, LNC.LNC_ATTRIBUTE_CATEGORY
, LNC.LNC_ATTRIBUTE1
, LNC.LNC_ATTRIBUTE2
, LNC.LNC_ATTRIBUTE3
, LNC.LNC_ATTRIBUTE4
, LNC.LNC_ATTRIBUTE5
, LNC.LNC_ATTRIBUTE6
, LNC.LNC_ATTRIBUTE7
, LNC.LNC_ATTRIBUTE8
, LNC.LNC_ATTRIBUTE9
, LNC.LNC_ATTRIBUTE10
, LNC.LNC_ATTRIBUTE11
, LNC.LNC_ATTRIBUTE12
, LNC.LNC_ATTRIBUTE13
, LNC.LNC_ATTRIBUTE14
, LNC.LNC_ATTRIBUTE15
, LNC.LNC_ATTRIBUTE16
, LNC.LNC_ATTRIBUTE17
, LNC.LNC_ATTRIBUTE18
, LNC.LNC_ATTRIBUTE19
, LNC.LNC_ATTRIBUTE20
, LNC.LNC_ATTRIBUTE21
, LNC.LNC_ATTRIBUTE22
, LNC.LNC_ATTRIBUTE23
, LNC.LNC_ATTRIBUTE24
, LNC.LNC_ATTRIBUTE25
, LNC.LNC_ATTRIBUTE26
, LNC.LNC_ATTRIBUTE27
, LNC.LNC_ATTRIBUTE28
, LNC.LNC_ATTRIBUTE29
, LNC.LNC_ATTRIBUTE30
, LNC.LAST_UPDATE_DATE
, LNC.LAST_UPDATED_BY
, LNC.LAST_UPDATE_LOGIN
, LNC.CREATED_BY
, LNC.CREATION_DATE
, LNC.OBJECT_VERSION_NUMBER
FROM BEN_LER_ENRT_CTFN_F LNC
WHERE LNC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LNC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))