Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LER_CHG_DPNT_CVG |
SELECT LDC.LER_CHG_DPNT_CVG_ID
, LDC.EFFECTIVE_START_DATE
, LDC.EFFECTIVE_END_DATE
, LDC.PL_ID
, LDC.PGM_ID
, LDC.BUSINESS_GROUP_ID
, LDC.LER_ID
, LDC.PTIP_ID
, LDC.ADD_RMV_CVG_CD
, LDC.CVG_EFF_END_CD
, LDC.CVG_EFF_STRT_CD
, LDC.LER_CHG_DPNT_CVG_RL
, LDC.LER_CHG_DPNT_CVG_CD
, LDC.CVG_EFF_STRT_RL
, LDC.CVG_EFF_END_RL
, LDC.LDC_ATTRIBUTE_CATEGORY
, LDC.LDC_ATTRIBUTE1
, LDC.LDC_ATTRIBUTE2
, LDC.LDC_ATTRIBUTE3
, LDC.LDC_ATTRIBUTE4
, LDC.LDC_ATTRIBUTE5
, LDC.LDC_ATTRIBUTE6
, LDC.LDC_ATTRIBUTE7
, LDC.LDC_ATTRIBUTE8
, LDC.LDC_ATTRIBUTE9
, LDC.LDC_ATTRIBUTE10
, LDC.LDC_ATTRIBUTE11
, LDC.LDC_ATTRIBUTE12
, LDC.LDC_ATTRIBUTE13
, LDC.LDC_ATTRIBUTE14
, LDC.LDC_ATTRIBUTE15
, LDC.LDC_ATTRIBUTE16
, LDC.LDC_ATTRIBUTE17
, LDC.LDC_ATTRIBUTE18
, LDC.LDC_ATTRIBUTE19
, LDC.LDC_ATTRIBUTE20
, LDC.LDC_ATTRIBUTE21
, LDC.LDC_ATTRIBUTE22
, LDC.LDC_ATTRIBUTE23
, LDC.LDC_ATTRIBUTE24
, LDC.LDC_ATTRIBUTE25
, LDC.LDC_ATTRIBUTE26
, LDC.LDC_ATTRIBUTE27
, LDC.LDC_ATTRIBUTE28
, LDC.LDC_ATTRIBUTE29
, LDC.LDC_ATTRIBUTE30
, LDC.LAST_UPDATE_DATE
, LDC.LAST_UPDATED_BY
, LDC.LAST_UPDATE_LOGIN
, LDC.CREATED_BY
, LDC.CREATION_DATE
, LDC.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_DPNT_CVG_F LDC
WHERE LDC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LDC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))