Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LER_CHG_DPNT_CVG_CTFN_X |
SELECT LCC.LER_CHG_DPNT_CVG_CTFN_ID
, LCC.EFFECTIVE_START_DATE
, LCC.EFFECTIVE_END_DATE
, LCC.DPNT_CVG_CTFN_TYP_CD
, LCC.RLSHP_TYP_CD
, LCC.CTFN_RQD_WHEN_RL
, LCC.LACK_CTFN_SSPND_ENRT_FLAG
, LCC.RQD_FLAG
, LCC.LER_CHG_DPNT_CVG_ID
, LCC.BUSINESS_GROUP_ID
, LCC.LCC_ATTRIBUTE_CATEGORY
, LCC.LCC_ATTRIBUTE1
, LCC.LCC_ATTRIBUTE2
, LCC.LCC_ATTRIBUTE3
, LCC.LCC_ATTRIBUTE4
, LCC.LCC_ATTRIBUTE5
, LCC.LCC_ATTRIBUTE6
, LCC.LCC_ATTRIBUTE7
, LCC.LCC_ATTRIBUTE8
, LCC.LCC_ATTRIBUTE9
, LCC.LCC_ATTRIBUTE10
, LCC.LCC_ATTRIBUTE11
, LCC.LCC_ATTRIBUTE12
, LCC.LCC_ATTRIBUTE13
, LCC.LCC_ATTRIBUTE14
, LCC.LCC_ATTRIBUTE15
, LCC.LCC_ATTRIBUTE16
, LCC.LCC_ATTRIBUTE17
, LCC.LCC_ATTRIBUTE18
, LCC.LCC_ATTRIBUTE19
, LCC.LCC_ATTRIBUTE20
, LCC.LCC_ATTRIBUTE21
, LCC.LCC_ATTRIBUTE22
, LCC.LCC_ATTRIBUTE23
, LCC.LCC_ATTRIBUTE24
, LCC.LCC_ATTRIBUTE25
, LCC.LCC_ATTRIBUTE26
, LCC.LCC_ATTRIBUTE27
, LCC.LCC_ATTRIBUTE28
, LCC.LCC_ATTRIBUTE29
, LCC.LCC_ATTRIBUTE30
, LCC.LAST_UPDATE_DATE
, LCC.LAST_UPDATED_BY
, LCC.LAST_UPDATE_LOGIN
, LCC.CREATED_BY
, LCC.CREATION_DATE
, LCC.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_DPNT_CVG_CTFN_F LCC
WHERE TRUNC(SYSDATE) BETWEEN LCC.EFFECTIVE_START_DATE
AND LCC.EFFECTIVE_END_DATE