VIEW: APPS.BEN_ELIG_MRTL_STAT_CVG_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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