VIEW: APPS.BEN_LER_CHG_DPNT_CVG_V

Source

View Text - Preformatted

SELECT LDC.ROWID ROW_ID ,LER.NAME LER_NAME , LDC.LER_CHG_DPNT_CVG_ID , LDC.EFFECTIVE_START_DATE , LDC.EFFECTIVE_END_DATE , LDC.PL_ID , LDC.PGM_ID , LDC.BUSINESS_GROUP_ID , LDC.LER_ID , LDC.PTIP_ID , LDC.ADD_RMV_CVG_CD , LDC.CVG_EFF_END_CD , LDC.CVG_EFF_STRT_CD , LDC.LER_CHG_DPNT_CVG_RL , LDC.LER_CHG_DPNT_CVG_CD , LDC.CVG_EFF_STRT_RL , LDC.CVG_EFF_END_RL ,LDC.susp_if_ctfn_not_prvd_flag ,LDC.ctfn_determine_cd , LDC.LDC_ATTRIBUTE_CATEGORY , LDC.LDC_ATTRIBUTE1 , LDC.LDC_ATTRIBUTE2 , LDC.LDC_ATTRIBUTE3 , LDC.LDC_ATTRIBUTE4 , LDC.LDC_ATTRIBUTE5 , LDC.LDC_ATTRIBUTE6 , LDC.LDC_ATTRIBUTE7 , LDC.LDC_ATTRIBUTE8 , LDC.LDC_ATTRIBUTE9 , LDC.LDC_ATTRIBUTE10 , LDC.LDC_ATTRIBUTE11 , LDC.LDC_ATTRIBUTE12 , LDC.LDC_ATTRIBUTE13 , LDC.LDC_ATTRIBUTE14 , LDC.LDC_ATTRIBUTE15 , LDC.LDC_ATTRIBUTE16 , LDC.LDC_ATTRIBUTE17 , LDC.LDC_ATTRIBUTE18 , LDC.LDC_ATTRIBUTE19 , LDC.LDC_ATTRIBUTE20 , LDC.LDC_ATTRIBUTE21 , LDC.LDC_ATTRIBUTE22 , LDC.LDC_ATTRIBUTE23 , LDC.LDC_ATTRIBUTE24 , LDC.LDC_ATTRIBUTE25 , LDC.LDC_ATTRIBUTE26 , LDC.LDC_ATTRIBUTE27 , LDC.LDC_ATTRIBUTE28 , LDC.LDC_ATTRIBUTE29 , LDC.LDC_ATTRIBUTE30 , LDC.LAST_UPDATE_DATE , LDC.LAST_UPDATED_BY , LDC.LAST_UPDATE_LOGIN , LDC.CREATED_BY , LDC.CREATION_DATE , LDC.OBJECT_VERSION_NUMBER FROM BEN_LER_CHG_DPNT_CVG_F LDC, FND_SESSIONS SE,BEN_LER_F LER WHERE SE.SESSION_ID = USERENV('sessionid') AND LER.LER_ID = LDC.LER_ID AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE AND LER.EFFECTIVE_END_DATE AND SE.EFFECTIVE_DATE BETWEEN LDC.EFFECTIVE_START_DATE AND LDC.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LDC.ROWID ROW_ID
, LER.NAME LER_NAME
, LDC.LER_CHG_DPNT_CVG_ID
, LDC.EFFECTIVE_START_DATE
, LDC.EFFECTIVE_END_DATE
, LDC.PL_ID
, LDC.PGM_ID
, LDC.BUSINESS_GROUP_ID
, LDC.LER_ID
, LDC.PTIP_ID
, LDC.ADD_RMV_CVG_CD
, LDC.CVG_EFF_END_CD
, LDC.CVG_EFF_STRT_CD
, LDC.LER_CHG_DPNT_CVG_RL
, LDC.LER_CHG_DPNT_CVG_CD
, LDC.CVG_EFF_STRT_RL
, LDC.CVG_EFF_END_RL
, LDC.SUSP_IF_CTFN_NOT_PRVD_FLAG
, LDC.CTFN_DETERMINE_CD
, LDC.LDC_ATTRIBUTE_CATEGORY
, LDC.LDC_ATTRIBUTE1
, LDC.LDC_ATTRIBUTE2
, LDC.LDC_ATTRIBUTE3
, LDC.LDC_ATTRIBUTE4
, LDC.LDC_ATTRIBUTE5
, LDC.LDC_ATTRIBUTE6
, LDC.LDC_ATTRIBUTE7
, LDC.LDC_ATTRIBUTE8
, LDC.LDC_ATTRIBUTE9
, LDC.LDC_ATTRIBUTE10
, LDC.LDC_ATTRIBUTE11
, LDC.LDC_ATTRIBUTE12
, LDC.LDC_ATTRIBUTE13
, LDC.LDC_ATTRIBUTE14
, LDC.LDC_ATTRIBUTE15
, LDC.LDC_ATTRIBUTE16
, LDC.LDC_ATTRIBUTE17
, LDC.LDC_ATTRIBUTE18
, LDC.LDC_ATTRIBUTE19
, LDC.LDC_ATTRIBUTE20
, LDC.LDC_ATTRIBUTE21
, LDC.LDC_ATTRIBUTE22
, LDC.LDC_ATTRIBUTE23
, LDC.LDC_ATTRIBUTE24
, LDC.LDC_ATTRIBUTE25
, LDC.LDC_ATTRIBUTE26
, LDC.LDC_ATTRIBUTE27
, LDC.LDC_ATTRIBUTE28
, LDC.LDC_ATTRIBUTE29
, LDC.LDC_ATTRIBUTE30
, LDC.LAST_UPDATE_DATE
, LDC.LAST_UPDATED_BY
, LDC.LAST_UPDATE_LOGIN
, LDC.CREATED_BY
, LDC.CREATION_DATE
, LDC.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_DPNT_CVG_F LDC
, FND_SESSIONS SE
, BEN_LER_F LER
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND LER.LER_ID = LDC.LER_ID
AND SE.EFFECTIVE_DATE BETWEEN LER.EFFECTIVE_START_DATE
AND LER.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN LDC.EFFECTIVE_START_DATE
AND LDC.EFFECTIVE_END_DATE