Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ELIG_MLTRY_STAT_CVG |
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'))