VIEW: APPS.BEN_LER_CHG_OIPL_ENRT_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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