VIEW: APPS.BEN_LER_CHG_DPNT_CVG_CTFN

Source

View Text - Preformatted

SELECT LCC.LER_CHG_DPNT_CVG_CTFN_ID , LCC.EFFECTIVE_START_DATE , LCC.EFFECTIVE_END_DATE , LCC.DPNT_CVG_CTFN_TYP_CD , LCC.RLSHP_TYP_CD , LCC.CTFN_RQD_WHEN_RL , LCC.LACK_CTFN_SSPND_ENRT_FLAG , LCC.RQD_FLAG , LCC.LER_CHG_DPNT_CVG_ID , LCC.BUSINESS_GROUP_ID , LCC.LCC_ATTRIBUTE_CATEGORY , LCC.LCC_ATTRIBUTE1 , LCC.LCC_ATTRIBUTE2 , LCC.LCC_ATTRIBUTE3 , LCC.LCC_ATTRIBUTE4 , LCC.LCC_ATTRIBUTE5 , LCC.LCC_ATTRIBUTE6 , LCC.LCC_ATTRIBUTE7 , LCC.LCC_ATTRIBUTE8 , LCC.LCC_ATTRIBUTE9 , LCC.LCC_ATTRIBUTE10 , LCC.LCC_ATTRIBUTE11 , LCC.LCC_ATTRIBUTE12 , LCC.LCC_ATTRIBUTE13 , LCC.LCC_ATTRIBUTE14 , LCC.LCC_ATTRIBUTE15 , LCC.LCC_ATTRIBUTE16 , LCC.LCC_ATTRIBUTE17 , LCC.LCC_ATTRIBUTE18 , LCC.LCC_ATTRIBUTE19 , LCC.LCC_ATTRIBUTE20 , LCC.LCC_ATTRIBUTE21 , LCC.LCC_ATTRIBUTE22 , LCC.LCC_ATTRIBUTE23 , LCC.LCC_ATTRIBUTE24 , LCC.LCC_ATTRIBUTE25 , LCC.LCC_ATTRIBUTE26 , LCC.LCC_ATTRIBUTE27 , LCC.LCC_ATTRIBUTE28 , LCC.LCC_ATTRIBUTE29 , LCC.LCC_ATTRIBUTE30 , LCC.LAST_UPDATE_DATE , LCC.LAST_UPDATED_BY , LCC.LAST_UPDATE_LOGIN , LCC.CREATED_BY , LCC.CREATION_DATE , LCC.OBJECT_VERSION_NUMBER FROM BEN_LER_CHG_DPNT_CVG_CTFN_F LCC WHERE LCC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND LCC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT LCC.LER_CHG_DPNT_CVG_CTFN_ID
, LCC.EFFECTIVE_START_DATE
, LCC.EFFECTIVE_END_DATE
, LCC.DPNT_CVG_CTFN_TYP_CD
, LCC.RLSHP_TYP_CD
, LCC.CTFN_RQD_WHEN_RL
, LCC.LACK_CTFN_SSPND_ENRT_FLAG
, LCC.RQD_FLAG
, LCC.LER_CHG_DPNT_CVG_ID
, LCC.BUSINESS_GROUP_ID
, LCC.LCC_ATTRIBUTE_CATEGORY
, LCC.LCC_ATTRIBUTE1
, LCC.LCC_ATTRIBUTE2
, LCC.LCC_ATTRIBUTE3
, LCC.LCC_ATTRIBUTE4
, LCC.LCC_ATTRIBUTE5
, LCC.LCC_ATTRIBUTE6
, LCC.LCC_ATTRIBUTE7
, LCC.LCC_ATTRIBUTE8
, LCC.LCC_ATTRIBUTE9
, LCC.LCC_ATTRIBUTE10
, LCC.LCC_ATTRIBUTE11
, LCC.LCC_ATTRIBUTE12
, LCC.LCC_ATTRIBUTE13
, LCC.LCC_ATTRIBUTE14
, LCC.LCC_ATTRIBUTE15
, LCC.LCC_ATTRIBUTE16
, LCC.LCC_ATTRIBUTE17
, LCC.LCC_ATTRIBUTE18
, LCC.LCC_ATTRIBUTE19
, LCC.LCC_ATTRIBUTE20
, LCC.LCC_ATTRIBUTE21
, LCC.LCC_ATTRIBUTE22
, LCC.LCC_ATTRIBUTE23
, LCC.LCC_ATTRIBUTE24
, LCC.LCC_ATTRIBUTE25
, LCC.LCC_ATTRIBUTE26
, LCC.LCC_ATTRIBUTE27
, LCC.LCC_ATTRIBUTE28
, LCC.LCC_ATTRIBUTE29
, LCC.LCC_ATTRIBUTE30
, LCC.LAST_UPDATE_DATE
, LCC.LAST_UPDATED_BY
, LCC.LAST_UPDATE_LOGIN
, LCC.CREATED_BY
, LCC.CREATION_DATE
, LCC.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_DPNT_CVG_CTFN_F LCC
WHERE LCC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LCC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))