VIEW: APPS.BEN_ELIG_AGE_CVG

Source

View Text - Preformatted

SELECT EAC.ELIG_AGE_CVG_ID , EAC.EFFECTIVE_START_DATE , EAC.EFFECTIVE_END_DATE , EAC.BUSINESS_GROUP_ID , EAC.DPNT_CVG_ELIGY_PRFL_ID , EAC.AGE_FCTR_ID , EAC.CVG_STRT_CD , EAC.CVG_STRT_RL , EAC.CVG_THRU_CD , EAC.CVG_THRU_RL , EAC.EXCLD_FLAG , EAC.EAC_ATTRIBUTE_CATEGORY , EAC.EAC_ATTRIBUTE1 , EAC.EAC_ATTRIBUTE2 , EAC.EAC_ATTRIBUTE3 , EAC.EAC_ATTRIBUTE4 , EAC.EAC_ATTRIBUTE5 , EAC.EAC_ATTRIBUTE6 , EAC.EAC_ATTRIBUTE7 , EAC.EAC_ATTRIBUTE8 , EAC.EAC_ATTRIBUTE9 , EAC.EAC_ATTRIBUTE10 , EAC.EAC_ATTRIBUTE11 , EAC.EAC_ATTRIBUTE12 , EAC.EAC_ATTRIBUTE13 , EAC.EAC_ATTRIBUTE14 , EAC.EAC_ATTRIBUTE15 , EAC.EAC_ATTRIBUTE16 , EAC.EAC_ATTRIBUTE17 , EAC.EAC_ATTRIBUTE18 , EAC.EAC_ATTRIBUTE19 , EAC.EAC_ATTRIBUTE20 , EAC.EAC_ATTRIBUTE21 , EAC.EAC_ATTRIBUTE22 , EAC.EAC_ATTRIBUTE23 , EAC.EAC_ATTRIBUTE24 , EAC.EAC_ATTRIBUTE25 , EAC.EAC_ATTRIBUTE26 , EAC.EAC_ATTRIBUTE27 , EAC.EAC_ATTRIBUTE28 , EAC.EAC_ATTRIBUTE29 , EAC.EAC_ATTRIBUTE30 , EAC.LAST_UPDATE_DATE , EAC.LAST_UPDATED_BY , EAC.LAST_UPDATE_LOGIN , EAC.CREATED_BY , EAC.CREATION_DATE , EAC.OBJECT_VERSION_NUMBER FROM BEN_ELIG_AGE_CVG_F EAC WHERE EAC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND EAC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT EAC.ELIG_AGE_CVG_ID
, EAC.EFFECTIVE_START_DATE
, EAC.EFFECTIVE_END_DATE
, EAC.BUSINESS_GROUP_ID
, EAC.DPNT_CVG_ELIGY_PRFL_ID
, EAC.AGE_FCTR_ID
, EAC.CVG_STRT_CD
, EAC.CVG_STRT_RL
, EAC.CVG_THRU_CD
, EAC.CVG_THRU_RL
, EAC.EXCLD_FLAG
, EAC.EAC_ATTRIBUTE_CATEGORY
, EAC.EAC_ATTRIBUTE1
, EAC.EAC_ATTRIBUTE2
, EAC.EAC_ATTRIBUTE3
, EAC.EAC_ATTRIBUTE4
, EAC.EAC_ATTRIBUTE5
, EAC.EAC_ATTRIBUTE6
, EAC.EAC_ATTRIBUTE7
, EAC.EAC_ATTRIBUTE8
, EAC.EAC_ATTRIBUTE9
, EAC.EAC_ATTRIBUTE10
, EAC.EAC_ATTRIBUTE11
, EAC.EAC_ATTRIBUTE12
, EAC.EAC_ATTRIBUTE13
, EAC.EAC_ATTRIBUTE14
, EAC.EAC_ATTRIBUTE15
, EAC.EAC_ATTRIBUTE16
, EAC.EAC_ATTRIBUTE17
, EAC.EAC_ATTRIBUTE18
, EAC.EAC_ATTRIBUTE19
, EAC.EAC_ATTRIBUTE20
, EAC.EAC_ATTRIBUTE21
, EAC.EAC_ATTRIBUTE22
, EAC.EAC_ATTRIBUTE23
, EAC.EAC_ATTRIBUTE24
, EAC.EAC_ATTRIBUTE25
, EAC.EAC_ATTRIBUTE26
, EAC.EAC_ATTRIBUTE27
, EAC.EAC_ATTRIBUTE28
, EAC.EAC_ATTRIBUTE29
, EAC.EAC_ATTRIBUTE30
, EAC.LAST_UPDATE_DATE
, EAC.LAST_UPDATED_BY
, EAC.LAST_UPDATE_LOGIN
, EAC.CREATED_BY
, EAC.CREATION_DATE
, EAC.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_AGE_CVG_F EAC
WHERE EAC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EAC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))