Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_LER_CHG_PTIP_ENRT_V |
SELECT LCT.ROWID ROW_ID
, LCT.LER_CHG_PTIP_ENRT_ID
, LCT.EFFECTIVE_START_DATE
, LCT.EFFECTIVE_END_DATE
, LCT.CRNT_ENRT_PRCLDS_CHG_FLAG
, LCT.STL_ELIG_CANT_CHG_FLAG
, LCT.DFLT_FLAG
, LCT.DFLT_ENRT_CD
, LCT.DFLT_ENRT_RL
, LCT.ENRT_CD
, LCT.ENRT_MTHD_CD
, LCT.ENRT_RL
, LCT.TCO_CHG_ENRT_CD
, LCT.PTIP_ID
, LCT.LER_ID
, LCT.BUSINESS_GROUP_ID
, LCT.LCT_ATTRIBUTE_CATEGORY
, LCT.LCT_ATTRIBUTE1
, LCT.LCT_ATTRIBUTE2
, LCT.LCT_ATTRIBUTE3
, LCT.LCT_ATTRIBUTE4
, LCT.LCT_ATTRIBUTE5
, LCT.LCT_ATTRIBUTE6
, LCT.LCT_ATTRIBUTE7
, LCT.LCT_ATTRIBUTE8
, LCT.LCT_ATTRIBUTE9
, LCT.LCT_ATTRIBUTE10
, LCT.LCT_ATTRIBUTE11
, LCT.LCT_ATTRIBUTE12
, LCT.LCT_ATTRIBUTE13
, LCT.LCT_ATTRIBUTE14
, LCT.LCT_ATTRIBUTE15
, LCT.LCT_ATTRIBUTE16
, LCT.LCT_ATTRIBUTE17
, LCT.LCT_ATTRIBUTE18
, LCT.LCT_ATTRIBUTE19
, LCT.LCT_ATTRIBUTE20
, LCT.LCT_ATTRIBUTE21
, LCT.LCT_ATTRIBUTE22
, LCT.LCT_ATTRIBUTE23
, LCT.LCT_ATTRIBUTE24
, LCT.LCT_ATTRIBUTE25
, LCT.LCT_ATTRIBUTE26
, LCT.LCT_ATTRIBUTE27
, LCT.LCT_ATTRIBUTE28
, LCT.LCT_ATTRIBUTE29
, LCT.LCT_ATTRIBUTE30
, LCT.LAST_UPDATE_DATE
, LCT.LAST_UPDATED_BY
, LCT.LAST_UPDATE_LOGIN
, LCT.CREATED_BY
, LCT.CREATION_DATE
, LCT.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_PTIP_ENRT_F LCT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LCT.EFFECTIVE_START_DATE
AND LCT.EFFECTIVE_END_DATE