VIEW: APPS.BEN_ELIG_MLTRY_STAT_CVG

Source

View Text - Preformatted

SELECT EMC.ELIG_MLTRY_STAT_CVG_ID , EMC.EFFECTIVE_START_DATE , EMC.EFFECTIVE_END_DATE , EMC.BUSINESS_GROUP_ID , EMC.DPNT_CVG_ELIGY_PRFL_ID , EMC.MLTRY_STAT_CD , EMC.CVG_STRT_CD , EMC.CVG_STRT_RL , EMC.CVG_THRU_CD , EMC.CVG_THRU_RL , EMC.EMC_ATTRIBUTE_CATEGORY , EMC.EMC_ATTRIBUTE1 , EMC.EMC_ATTRIBUTE2 , EMC.EMC_ATTRIBUTE3 , EMC.EMC_ATTRIBUTE4 , EMC.EMC_ATTRIBUTE5 , EMC.EMC_ATTRIBUTE6 , EMC.EMC_ATTRIBUTE7 , EMC.EMC_ATTRIBUTE8 , EMC.EMC_ATTRIBUTE9 , EMC.EMC_ATTRIBUTE10 , EMC.EMC_ATTRIBUTE11 , EMC.EMC_ATTRIBUTE12 , EMC.EMC_ATTRIBUTE13 , EMC.EMC_ATTRIBUTE14 , EMC.EMC_ATTRIBUTE15 , EMC.EMC_ATTRIBUTE16 , EMC.EMC_ATTRIBUTE17 , EMC.EMC_ATTRIBUTE18 , EMC.EMC_ATTRIBUTE19 , EMC.EMC_ATTRIBUTE20 , EMC.EMC_ATTRIBUTE21 , EMC.EMC_ATTRIBUTE22 , EMC.EMC_ATTRIBUTE23 , EMC.EMC_ATTRIBUTE24 , EMC.EMC_ATTRIBUTE25 , EMC.EMC_ATTRIBUTE26 , EMC.EMC_ATTRIBUTE27 , EMC.EMC_ATTRIBUTE28 , EMC.EMC_ATTRIBUTE29 , EMC.EMC_ATTRIBUTE30 , EMC.LAST_UPDATE_DATE , EMC.LAST_UPDATED_BY , EMC.LAST_UPDATE_LOGIN , EMC.CREATED_BY , EMC.CREATION_DATE , EMC.OBJECT_VERSION_NUMBER FROM BEN_ELIG_MLTRY_STAT_CVG_F EMC WHERE EMC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND EMC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT EMC.ELIG_MLTRY_STAT_CVG_ID
, EMC.EFFECTIVE_START_DATE
, EMC.EFFECTIVE_END_DATE
, EMC.BUSINESS_GROUP_ID
, EMC.DPNT_CVG_ELIGY_PRFL_ID
, EMC.MLTRY_STAT_CD
, EMC.CVG_STRT_CD
, EMC.CVG_STRT_RL
, EMC.CVG_THRU_CD
, EMC.CVG_THRU_RL
, EMC.EMC_ATTRIBUTE_CATEGORY
, EMC.EMC_ATTRIBUTE1
, EMC.EMC_ATTRIBUTE2
, EMC.EMC_ATTRIBUTE3
, EMC.EMC_ATTRIBUTE4
, EMC.EMC_ATTRIBUTE5
, EMC.EMC_ATTRIBUTE6
, EMC.EMC_ATTRIBUTE7
, EMC.EMC_ATTRIBUTE8
, EMC.EMC_ATTRIBUTE9
, EMC.EMC_ATTRIBUTE10
, EMC.EMC_ATTRIBUTE11
, EMC.EMC_ATTRIBUTE12
, EMC.EMC_ATTRIBUTE13
, EMC.EMC_ATTRIBUTE14
, EMC.EMC_ATTRIBUTE15
, EMC.EMC_ATTRIBUTE16
, EMC.EMC_ATTRIBUTE17
, EMC.EMC_ATTRIBUTE18
, EMC.EMC_ATTRIBUTE19
, EMC.EMC_ATTRIBUTE20
, EMC.EMC_ATTRIBUTE21
, EMC.EMC_ATTRIBUTE22
, EMC.EMC_ATTRIBUTE23
, EMC.EMC_ATTRIBUTE24
, EMC.EMC_ATTRIBUTE25
, EMC.EMC_ATTRIBUTE26
, EMC.EMC_ATTRIBUTE27
, EMC.EMC_ATTRIBUTE28
, EMC.EMC_ATTRIBUTE29
, EMC.EMC_ATTRIBUTE30
, EMC.LAST_UPDATE_DATE
, EMC.LAST_UPDATED_BY
, EMC.LAST_UPDATE_LOGIN
, EMC.CREATED_BY
, EMC.CREATION_DATE
, EMC.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_MLTRY_STAT_CVG_F EMC
WHERE EMC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EMC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))