VIEW: APPS.BEN_LER_CHG_PTIP_ENRT_V

Source

View Text - Preformatted

SELECT lct.ROWID ROW_ID , LER.NAME LER_NAME ,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,BEN_LER_F LER WHERE se.session_id = userenv('sessionid') and se.effective_date between lct.effective_start_date and lct.effective_end_date AND LER.LER_ID = LCT.LER_ID AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE AND LER.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LCT.ROWID ROW_ID
, LER.NAME LER_NAME
, 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
, BEN_LER_F LER
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LCT.EFFECTIVE_START_DATE
AND LCT.EFFECTIVE_END_DATE
AND LER.LER_ID = LCT.LER_ID
AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE
AND LER.EFFECTIVE_END_DATE