Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_LER_ENRT_CTFN |
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'))