VIEW: APPS.BEN_ELIG_PPL_GRP_PRTE_X

Source

View Text - Preformatted

SELECT epg.ELIG_PPL_GRP_PRTE_ID ,epg.EFFECTIVE_START_DATE ,epg.EFFECTIVE_END_DATE ,epg.EXCLD_FLAG ,epg.ORDR_NUM ,epg.ELIGY_PRFL_ID ,epg.PEOPLE_GROUP_ID ,epg.BUSINESS_GROUP_ID , EPG.CRITERIA_SCORE , EPG.CRITERIA_WEIGHT ,epg.EPG_ATTRIBUTE_CATEGORY ,epg.EPG_ATTRIBUTE1 ,epg.EPG_ATTRIBUTE2 ,epg.EPG_ATTRIBUTE3 ,epg.EPG_ATTRIBUTE4 ,epg.EPG_ATTRIBUTE5 ,epg.EPG_ATTRIBUTE6 ,epg.EPG_ATTRIBUTE7 ,epg.EPG_ATTRIBUTE8 ,epg.EPG_ATTRIBUTE9 ,epg.EPG_ATTRIBUTE10 ,epg.EPG_ATTRIBUTE11 ,epg.EPG_ATTRIBUTE12 ,epg.EPG_ATTRIBUTE13 ,epg.EPG_ATTRIBUTE14 ,epg.EPG_ATTRIBUTE15 ,epg.EPG_ATTRIBUTE16 ,epg.EPG_ATTRIBUTE17 ,epg.EPG_ATTRIBUTE18 ,epg.EPG_ATTRIBUTE19 ,epg.EPG_ATTRIBUTE20 ,epg.EPG_ATTRIBUTE21 ,epg.EPG_ATTRIBUTE22 ,epg.EPG_ATTRIBUTE23 ,epg.EPG_ATTRIBUTE24 ,epg.EPG_ATTRIBUTE25 ,epg.EPG_ATTRIBUTE26 ,epg.EPG_ATTRIBUTE27 ,epg.EPG_ATTRIBUTE28 ,epg.EPG_ATTRIBUTE29 ,epg.EPG_ATTRIBUTE30 ,epg.LAST_UPDATE_DATE ,epg.LAST_UPDATED_BY ,epg.LAST_UPDATE_LOGIN ,epg.CREATED_BY ,epg.CREATION_DATE ,epg.OBJECT_VERSION_NUMBER from BEN_ELIG_PPL_GRP_PRTE_F epg WHERE trunc(sysdate) between epg.effective_start_date and epg.effective_end_date

View Text - HTML Formatted

SELECT EPG.ELIG_PPL_GRP_PRTE_ID
, EPG.EFFECTIVE_START_DATE
, EPG.EFFECTIVE_END_DATE
, EPG.EXCLD_FLAG
, EPG.ORDR_NUM
, EPG.ELIGY_PRFL_ID
, EPG.PEOPLE_GROUP_ID
, EPG.BUSINESS_GROUP_ID
, EPG.CRITERIA_SCORE
, EPG.CRITERIA_WEIGHT
, EPG.EPG_ATTRIBUTE_CATEGORY
, EPG.EPG_ATTRIBUTE1
, EPG.EPG_ATTRIBUTE2
, EPG.EPG_ATTRIBUTE3
, EPG.EPG_ATTRIBUTE4
, EPG.EPG_ATTRIBUTE5
, EPG.EPG_ATTRIBUTE6
, EPG.EPG_ATTRIBUTE7
, EPG.EPG_ATTRIBUTE8
, EPG.EPG_ATTRIBUTE9
, EPG.EPG_ATTRIBUTE10
, EPG.EPG_ATTRIBUTE11
, EPG.EPG_ATTRIBUTE12
, EPG.EPG_ATTRIBUTE13
, EPG.EPG_ATTRIBUTE14
, EPG.EPG_ATTRIBUTE15
, EPG.EPG_ATTRIBUTE16
, EPG.EPG_ATTRIBUTE17
, EPG.EPG_ATTRIBUTE18
, EPG.EPG_ATTRIBUTE19
, EPG.EPG_ATTRIBUTE20
, EPG.EPG_ATTRIBUTE21
, EPG.EPG_ATTRIBUTE22
, EPG.EPG_ATTRIBUTE23
, EPG.EPG_ATTRIBUTE24
, EPG.EPG_ATTRIBUTE25
, EPG.EPG_ATTRIBUTE26
, EPG.EPG_ATTRIBUTE27
, EPG.EPG_ATTRIBUTE28
, EPG.EPG_ATTRIBUTE29
, EPG.EPG_ATTRIBUTE30
, EPG.LAST_UPDATE_DATE
, EPG.LAST_UPDATED_BY
, EPG.LAST_UPDATE_LOGIN
, EPG.CREATED_BY
, EPG.CREATION_DATE
, EPG.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PPL_GRP_PRTE_F EPG
WHERE TRUNC(SYSDATE) BETWEEN EPG.EFFECTIVE_START_DATE
AND EPG.EFFECTIVE_END_DATE