View: BEN_ELIG_MRTL_STAT_CVG_X

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

View Text

SELECT EMS.ELIG_MRTL_STAT_CVG_ID
, EMS.EFFECTIVE_START_DATE
, EMS.EFFECTIVE_END_DATE
, EMS.BUSINESS_GROUP_ID
, EMS.DPNT_CVG_ELIGY_PRFL_ID
, EMS.MRTL_STAT_CD
, EMS.CVG_STRT_CD
, EMS.CVG_STRT_RL
, EMS.CVG_THRU_CD
, EMS.CVG_THRU_RL
, EMS.EMS_ATTRIBUTE_CATEGORY
, EMS.EMS_ATTRIBUTE1
, EMS.EMS_ATTRIBUTE2
, EMS.EMS_ATTRIBUTE3
, EMS.EMS_ATTRIBUTE4
, EMS.EMS_ATTRIBUTE5
, EMS.EMS_ATTRIBUTE6
, EMS.EMS_ATTRIBUTE7
, EMS.EMS_ATTRIBUTE8
, EMS.EMS_ATTRIBUTE9
, EMS.EMS_ATTRIBUTE10
, EMS.EMS_ATTRIBUTE11
, EMS.EMS_ATTRIBUTE12
, EMS.EMS_ATTRIBUTE13
, EMS.EMS_ATTRIBUTE14
, EMS.EMS_ATTRIBUTE15
, EMS.EMS_ATTRIBUTE16
, EMS.EMS_ATTRIBUTE17
, EMS.EMS_ATTRIBUTE18
, EMS.EMS_ATTRIBUTE19
, EMS.EMS_ATTRIBUTE20
, EMS.EMS_ATTRIBUTE21
, EMS.EMS_ATTRIBUTE22
, EMS.EMS_ATTRIBUTE23
, EMS.EMS_ATTRIBUTE24
, EMS.EMS_ATTRIBUTE25
, EMS.EMS_ATTRIBUTE26
, EMS.EMS_ATTRIBUTE27
, EMS.EMS_ATTRIBUTE28
, EMS.EMS_ATTRIBUTE29
, EMS.EMS_ATTRIBUTE30
, EMS.LAST_UPDATE_DATE
, EMS.LAST_UPDATED_BY
, EMS.LAST_UPDATE_LOGIN
, EMS.CREATED_BY
, EMS.CREATION_DATE
, EMS.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_MRTL_STAT_CVG_F EMS
WHERE TRUNC(SYSDATE) BETWEEN EMS.EFFECTIVE_START_DATE
AND EMS.EFFECTIVE_END_DATE

Columns