Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_LER_CHG_OIPL_ENRT_X |
SELECT LOP.LER_CHG_OIPL_ENRT_ID
, LOP.EFFECTIVE_START_DATE
, LOP.EFFECTIVE_END_DATE
, LOP.BUSINESS_GROUP_ID
, LOP.OIPL_ID
, LOP.LER_ID
, LOP.AUTO_ENRT_MTHD_RL
, LOP.CRNT_ENRT_PRCLDS_CHG_FLAG
, LOP.ENRT_CD
, LOP.ENRT_RL
, LOP.DFLT_ENRT_RL
, LOP.DFLT_ENRT_CD
, LOP.DFLT_FLAG
, LOP.STL_ELIG_CANT_CHG_FLAG
, LOP.AUTO_ENRT_FLAG
, LOP.LOP_ATTRIBUTE_CATEGORY
, LOP.LOP_ATTRIBUTE1
, LOP.LOP_ATTRIBUTE2
, LOP.LOP_ATTRIBUTE3
, LOP.LOP_ATTRIBUTE4
, LOP.LOP_ATTRIBUTE5
, LOP.LOP_ATTRIBUTE6
, LOP.LOP_ATTRIBUTE7
, LOP.LOP_ATTRIBUTE8
, LOP.LOP_ATTRIBUTE9
, LOP.LOP_ATTRIBUTE10
, LOP.LOP_ATTRIBUTE11
, LOP.LOP_ATTRIBUTE12
, LOP.LOP_ATTRIBUTE13
, LOP.LOP_ATTRIBUTE14
, LOP.LOP_ATTRIBUTE15
, LOP.LOP_ATTRIBUTE16
, LOP.LOP_ATTRIBUTE17
, LOP.LOP_ATTRIBUTE18
, LOP.LOP_ATTRIBUTE19
, LOP.LOP_ATTRIBUTE20
, LOP.LOP_ATTRIBUTE21
, LOP.LOP_ATTRIBUTE22
, LOP.LOP_ATTRIBUTE23
, LOP.LOP_ATTRIBUTE24
, LOP.LOP_ATTRIBUTE25
, LOP.LOP_ATTRIBUTE26
, LOP.LOP_ATTRIBUTE27
, LOP.LOP_ATTRIBUTE28
, LOP.LOP_ATTRIBUTE29
, LOP.LOP_ATTRIBUTE30
, LOP.LAST_UPDATE_DATE
, LOP.LAST_UPDATED_BY
, LOP.LAST_UPDATE_LOGIN
, LOP.CREATED_BY
, LOP.CREATION_DATE
, LOP.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_OIPL_ENRT_F LOP
WHERE TRUNC(SYSDATE) BETWEEN LOP.EFFECTIVE_START_DATE
AND LOP.EFFECTIVE_END_DATE