VIEW: APPS.BEN_LER_CHG_PL_NIP_ENRT_V

Source

View Text - Preformatted

SELECT LPE.ROWID ROW_ID , LPE.LER_CHG_PL_NIP_ENRT_ID , LPE.EFFECTIVE_START_DATE , LPE.EFFECTIVE_END_DATE , LPE.BUSINESS_GROUP_ID , LPE.PL_ID , LPE.LER_ID , LPE.TCO_CHG_ENRT_CD , LPE.CRNT_ENRT_PRCLDS_CHG_FLAG , LPE.DFLT_ENRT_CD , LPE.DFLT_ENRT_RL , LPE.DFLT_FLAG , LPE.ENRT_RL , LPE.ENRT_CD , LPE.STL_ELIG_CANT_CHG_FLAG , LPE.ENRT_MTHD_CD , LPE.AUTO_ENRT_MTHD_RL , LPE.LPE_ATTRIBUTE_CATEGORY , LPE.LPE_ATTRIBUTE1 , LPE.LPE_ATTRIBUTE2 , LPE.LPE_ATTRIBUTE3 , LPE.LPE_ATTRIBUTE4 , LPE.LPE_ATTRIBUTE5 , LPE.LPE_ATTRIBUTE6 , LPE.LPE_ATTRIBUTE7 , LPE.LPE_ATTRIBUTE8 , LPE.LPE_ATTRIBUTE9 , LPE.LPE_ATTRIBUTE10 , LPE.LPE_ATTRIBUTE11 , LPE.LPE_ATTRIBUTE12 , LPE.LPE_ATTRIBUTE13 , LPE.LPE_ATTRIBUTE14 , LPE.LPE_ATTRIBUTE15 , LPE.LPE_ATTRIBUTE16 , LPE.LPE_ATTRIBUTE17 , LPE.LPE_ATTRIBUTE18 , LPE.LPE_ATTRIBUTE19 , LPE.LPE_ATTRIBUTE20 , LPE.LPE_ATTRIBUTE21 , LPE.LPE_ATTRIBUTE22 , LPE.LPE_ATTRIBUTE23 , LPE.LPE_ATTRIBUTE24 , LPE.LPE_ATTRIBUTE25 , LPE.LPE_ATTRIBUTE26 , LPE.LPE_ATTRIBUTE27 , LPE.LPE_ATTRIBUTE28 , LPE.LPE_ATTRIBUTE29 , LPE.LPE_ATTRIBUTE30 , LPE.LAST_UPDATE_DATE , LPE.LAST_UPDATED_BY , LPE.LAST_UPDATE_LOGIN , LPE.CREATED_BY , LPE.CREATION_DATE , LPE.OBJECT_VERSION_NUMBER , LER.NAME LER_NAME FROM BEN_LER_CHG_PL_NIP_ENRT_F LPE, FND_SESSIONS SE,BEN_LER_F LER WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN LPE.EFFECTIVE_START_DATE AND LPE.EFFECTIVE_END_DATE AND LER.LER_ID = LPE.LER_ID AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE AND LER.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LPE.ROWID ROW_ID
, LPE.LER_CHG_PL_NIP_ENRT_ID
, LPE.EFFECTIVE_START_DATE
, LPE.EFFECTIVE_END_DATE
, LPE.BUSINESS_GROUP_ID
, LPE.PL_ID
, LPE.LER_ID
, LPE.TCO_CHG_ENRT_CD
, LPE.CRNT_ENRT_PRCLDS_CHG_FLAG
, LPE.DFLT_ENRT_CD
, LPE.DFLT_ENRT_RL
, LPE.DFLT_FLAG
, LPE.ENRT_RL
, LPE.ENRT_CD
, LPE.STL_ELIG_CANT_CHG_FLAG
, LPE.ENRT_MTHD_CD
, LPE.AUTO_ENRT_MTHD_RL
, LPE.LPE_ATTRIBUTE_CATEGORY
, LPE.LPE_ATTRIBUTE1
, LPE.LPE_ATTRIBUTE2
, LPE.LPE_ATTRIBUTE3
, LPE.LPE_ATTRIBUTE4
, LPE.LPE_ATTRIBUTE5
, LPE.LPE_ATTRIBUTE6
, LPE.LPE_ATTRIBUTE7
, LPE.LPE_ATTRIBUTE8
, LPE.LPE_ATTRIBUTE9
, LPE.LPE_ATTRIBUTE10
, LPE.LPE_ATTRIBUTE11
, LPE.LPE_ATTRIBUTE12
, LPE.LPE_ATTRIBUTE13
, LPE.LPE_ATTRIBUTE14
, LPE.LPE_ATTRIBUTE15
, LPE.LPE_ATTRIBUTE16
, LPE.LPE_ATTRIBUTE17
, LPE.LPE_ATTRIBUTE18
, LPE.LPE_ATTRIBUTE19
, LPE.LPE_ATTRIBUTE20
, LPE.LPE_ATTRIBUTE21
, LPE.LPE_ATTRIBUTE22
, LPE.LPE_ATTRIBUTE23
, LPE.LPE_ATTRIBUTE24
, LPE.LPE_ATTRIBUTE25
, LPE.LPE_ATTRIBUTE26
, LPE.LPE_ATTRIBUTE27
, LPE.LPE_ATTRIBUTE28
, LPE.LPE_ATTRIBUTE29
, LPE.LPE_ATTRIBUTE30
, LPE.LAST_UPDATE_DATE
, LPE.LAST_UPDATED_BY
, LPE.LAST_UPDATE_LOGIN
, LPE.CREATED_BY
, LPE.CREATION_DATE
, LPE.OBJECT_VERSION_NUMBER
, LER.NAME LER_NAME
FROM BEN_LER_CHG_PL_NIP_ENRT_F LPE
, FND_SESSIONS SE
, BEN_LER_F LER
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LPE.EFFECTIVE_START_DATE
AND LPE.EFFECTIVE_END_DATE
AND LER.LER_ID = LPE.LER_ID
AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE
AND LER.EFFECTIVE_END_DATE