View: BEN_ELIG_MLTRY_STAT_CVG_X

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_ELIG_MLTRY_STAT_CVG_X

View Text

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 TRUNC(SYSDATE) BETWEEN EMC.EFFECTIVE_START_DATE
AND EMC.EFFECTIVE_END_DATE

Columns