VIEW: APPS.BEN_ELIG_DPNT_CVRD_OTHR_PL_X

Source

View Text - Preformatted

SELECT edp.ELIG_DPNT_CVRD_OTHR_PL_ID ,edp.EFFECTIVE_START_DATE ,edp.EFFECTIVE_END_DATE ,edp.ORDR_NUM ,edp.EXCLD_FLAG ,edp.CVG_DET_DT_CD ,edp.BUSINESS_GROUP_ID ,edp.ELIGY_PRFL_ID ,edp.PL_ID ,edp.EDP_ATTRIBUTE_CATEGORY ,edp.EDP_ATTRIBUTE1 ,edp.EDP_ATTRIBUTE2 ,edp.EDP_ATTRIBUTE3 ,edp.EDP_ATTRIBUTE4 ,edp.EDP_ATTRIBUTE5 ,edp.EDP_ATTRIBUTE6 ,edp.EDP_ATTRIBUTE7 ,edp.EDP_ATTRIBUTE8 ,edp.EDP_ATTRIBUTE9 ,edp.EDP_ATTRIBUTE10 ,edp.EDP_ATTRIBUTE11 ,edp.EDP_ATTRIBUTE12 ,edp.EDP_ATTRIBUTE13 ,edp.EDP_ATTRIBUTE14 ,edp.EDP_ATTRIBUTE15 ,edp.EDP_ATTRIBUTE16 ,edp.EDP_ATTRIBUTE17 ,edp.EDP_ATTRIBUTE18 ,edp.EDP_ATTRIBUTE19 ,edp.EDP_ATTRIBUTE20 ,edp.EDP_ATTRIBUTE21 ,edp.EDP_ATTRIBUTE22 ,edp.EDP_ATTRIBUTE23 ,edp.EDP_ATTRIBUTE24 ,edp.EDP_ATTRIBUTE25 ,edp.EDP_ATTRIBUTE26 ,edp.EDP_ATTRIBUTE27 ,edp.EDP_ATTRIBUTE28 ,edp.EDP_ATTRIBUTE29 ,edp.EDP_ATTRIBUTE30 ,edp.LAST_UPDATE_DATE ,edp.LAST_UPDATED_BY ,edp.LAST_UPDATE_LOGIN ,edp.CREATED_BY ,edp.CREATION_DATE ,edp.OBJECT_VERSION_NUMBER from BEN_ELIG_DPNT_CVRD_OTHR_PL_F edp WHERE trunc(sysdate) between edp.effective_start_date and edp.effective_end_date

View Text - HTML Formatted

SELECT EDP.ELIG_DPNT_CVRD_OTHR_PL_ID
, EDP.EFFECTIVE_START_DATE
, EDP.EFFECTIVE_END_DATE
, EDP.ORDR_NUM
, EDP.EXCLD_FLAG
, EDP.CVG_DET_DT_CD
, EDP.BUSINESS_GROUP_ID
, EDP.ELIGY_PRFL_ID
, EDP.PL_ID
, EDP.EDP_ATTRIBUTE_CATEGORY
, EDP.EDP_ATTRIBUTE1
, EDP.EDP_ATTRIBUTE2
, EDP.EDP_ATTRIBUTE3
, EDP.EDP_ATTRIBUTE4
, EDP.EDP_ATTRIBUTE5
, EDP.EDP_ATTRIBUTE6
, EDP.EDP_ATTRIBUTE7
, EDP.EDP_ATTRIBUTE8
, EDP.EDP_ATTRIBUTE9
, EDP.EDP_ATTRIBUTE10
, EDP.EDP_ATTRIBUTE11
, EDP.EDP_ATTRIBUTE12
, EDP.EDP_ATTRIBUTE13
, EDP.EDP_ATTRIBUTE14
, EDP.EDP_ATTRIBUTE15
, EDP.EDP_ATTRIBUTE16
, EDP.EDP_ATTRIBUTE17
, EDP.EDP_ATTRIBUTE18
, EDP.EDP_ATTRIBUTE19
, EDP.EDP_ATTRIBUTE20
, EDP.EDP_ATTRIBUTE21
, EDP.EDP_ATTRIBUTE22
, EDP.EDP_ATTRIBUTE23
, EDP.EDP_ATTRIBUTE24
, EDP.EDP_ATTRIBUTE25
, EDP.EDP_ATTRIBUTE26
, EDP.EDP_ATTRIBUTE27
, EDP.EDP_ATTRIBUTE28
, EDP.EDP_ATTRIBUTE29
, EDP.EDP_ATTRIBUTE30
, EDP.LAST_UPDATE_DATE
, EDP.LAST_UPDATED_BY
, EDP.LAST_UPDATE_LOGIN
, EDP.CREATED_BY
, EDP.CREATION_DATE
, EDP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP
WHERE TRUNC(SYSDATE) BETWEEN EDP.EFFECTIVE_START_DATE
AND EDP.EFFECTIVE_END_DATE