VIEW: APPS.BEN_ELIG_HRLY_SLRD_PRTE_X

Source

View Text - Preformatted

SELECT EHS.ELIG_HRLY_SLRD_PRTE_ID , EHS.EFFECTIVE_START_DATE , EHS.EFFECTIVE_END_DATE , EHS.ORDR_NUM , EHS.HRLY_SLRD_CD , EHS.EXCLD_FLAG , EHS.ELIGY_PRFL_ID , EHS.BUSINESS_GROUP_ID , EHS.CRITERIA_SCORE , EHS.CRITERIA_WEIGHT , EHS.EHS_ATTRIBUTE_CATEGORY , EHS.EHS_ATTRIBUTE1 , EHS.EHS_ATTRIBUTE2 , EHS.EHS_ATTRIBUTE3 , EHS.EHS_ATTRIBUTE4 , EHS.EHS_ATTRIBUTE5 , EHS.EHS_ATTRIBUTE6 , EHS.EHS_ATTRIBUTE7 , EHS.EHS_ATTRIBUTE8 , EHS.EHS_ATTRIBUTE9 , EHS.EHS_ATTRIBUTE10 , EHS.EHS_ATTRIBUTE11 , EHS.EHS_ATTRIBUTE12 , EHS.EHS_ATTRIBUTE13 , EHS.EHS_ATTRIBUTE14 , EHS.EHS_ATTRIBUTE15 , EHS.EHS_ATTRIBUTE16 , EHS.EHS_ATTRIBUTE17 , EHS.EHS_ATTRIBUTE18 , EHS.EHS_ATTRIBUTE19 , EHS.EHS_ATTRIBUTE20 , EHS.EHS_ATTRIBUTE21 , EHS.EHS_ATTRIBUTE22 , EHS.EHS_ATTRIBUTE23 , EHS.EHS_ATTRIBUTE24 , EHS.EHS_ATTRIBUTE25 , EHS.EHS_ATTRIBUTE26 , EHS.EHS_ATTRIBUTE27 , EHS.EHS_ATTRIBUTE28 , EHS.EHS_ATTRIBUTE29 , EHS.EHS_ATTRIBUTE30 , EHS.LAST_UPDATE_DATE , EHS.LAST_UPDATED_BY , EHS.LAST_UPDATE_LOGIN , EHS.CREATED_BY , EHS.CREATION_DATE , EHS.OBJECT_VERSION_NUMBER FROM BEN_ELIG_HRLY_SLRD_PRTE_F EHS WHERE TRUNC(SYSDATE) BETWEEN EHS.EFFECTIVE_START_DATE AND EHS.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EHS.ELIG_HRLY_SLRD_PRTE_ID
, EHS.EFFECTIVE_START_DATE
, EHS.EFFECTIVE_END_DATE
, EHS.ORDR_NUM
, EHS.HRLY_SLRD_CD
, EHS.EXCLD_FLAG
, EHS.ELIGY_PRFL_ID
, EHS.BUSINESS_GROUP_ID
, EHS.CRITERIA_SCORE
, EHS.CRITERIA_WEIGHT
, EHS.EHS_ATTRIBUTE_CATEGORY
, EHS.EHS_ATTRIBUTE1
, EHS.EHS_ATTRIBUTE2
, EHS.EHS_ATTRIBUTE3
, EHS.EHS_ATTRIBUTE4
, EHS.EHS_ATTRIBUTE5
, EHS.EHS_ATTRIBUTE6
, EHS.EHS_ATTRIBUTE7
, EHS.EHS_ATTRIBUTE8
, EHS.EHS_ATTRIBUTE9
, EHS.EHS_ATTRIBUTE10
, EHS.EHS_ATTRIBUTE11
, EHS.EHS_ATTRIBUTE12
, EHS.EHS_ATTRIBUTE13
, EHS.EHS_ATTRIBUTE14
, EHS.EHS_ATTRIBUTE15
, EHS.EHS_ATTRIBUTE16
, EHS.EHS_ATTRIBUTE17
, EHS.EHS_ATTRIBUTE18
, EHS.EHS_ATTRIBUTE19
, EHS.EHS_ATTRIBUTE20
, EHS.EHS_ATTRIBUTE21
, EHS.EHS_ATTRIBUTE22
, EHS.EHS_ATTRIBUTE23
, EHS.EHS_ATTRIBUTE24
, EHS.EHS_ATTRIBUTE25
, EHS.EHS_ATTRIBUTE26
, EHS.EHS_ATTRIBUTE27
, EHS.EHS_ATTRIBUTE28
, EHS.EHS_ATTRIBUTE29
, EHS.EHS_ATTRIBUTE30
, EHS.LAST_UPDATE_DATE
, EHS.LAST_UPDATED_BY
, EHS.LAST_UPDATE_LOGIN
, EHS.CREATED_BY
, EHS.CREATION_DATE
, EHS.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_HRLY_SLRD_PRTE_F EHS
WHERE TRUNC(SYSDATE) BETWEEN EHS.EFFECTIVE_START_DATE
AND EHS.EFFECTIVE_END_DATE