VIEW: APPS.BEN_ELIG_PYRL_PRTE_X

Source

View Text - Preformatted

SELECT EPY.ELIG_PYRL_PRTE_ID , EPY.EFFECTIVE_START_DATE , EPY.EFFECTIVE_END_DATE , EPY.BUSINESS_GROUP_ID , EPY.PAYROLL_ID , EPY.EXCLD_FLAG , EPY.ORDR_NUM , EPY.ELIGY_PRFL_ID , EPY.CRITERIA_SCORE , EPY.CRITERIA_WEIGHT , EPY.EPY_ATTRIBUTE_CATEGORY , EPY.EPY_ATTRIBUTE1 , EPY.EPY_ATTRIBUTE2 , EPY.EPY_ATTRIBUTE3 , EPY.EPY_ATTRIBUTE4 , EPY.EPY_ATTRIBUTE5 , EPY.EPY_ATTRIBUTE6 , EPY.EPY_ATTRIBUTE7 , EPY.EPY_ATTRIBUTE8 , EPY.EPY_ATTRIBUTE9 , EPY.EPY_ATTRIBUTE10 , EPY.EPY_ATTRIBUTE11 , EPY.EPY_ATTRIBUTE12 , EPY.EPY_ATTRIBUTE13 , EPY.EPY_ATTRIBUTE14 , EPY.EPY_ATTRIBUTE15 , EPY.EPY_ATTRIBUTE16 , EPY.EPY_ATTRIBUTE17 , EPY.EPY_ATTRIBUTE18 , EPY.EPY_ATTRIBUTE19 , EPY.EPY_ATTRIBUTE20 , EPY.EPY_ATTRIBUTE21 , EPY.EPY_ATTRIBUTE22 , EPY.EPY_ATTRIBUTE23 , EPY.EPY_ATTRIBUTE24 , EPY.EPY_ATTRIBUTE25 , EPY.EPY_ATTRIBUTE26 , EPY.EPY_ATTRIBUTE27 , EPY.EPY_ATTRIBUTE28 , EPY.EPY_ATTRIBUTE29 , EPY.EPY_ATTRIBUTE30 , EPY.LAST_UPDATE_DATE , EPY.LAST_UPDATED_BY , EPY.LAST_UPDATE_LOGIN , EPY.CREATED_BY , EPY.CREATION_DATE , EPY.OBJECT_VERSION_NUMBER FROM BEN_ELIG_PYRL_PRTE_F EPY WHERE TRUNC(SYSDATE) BETWEEN EPY.EFFECTIVE_START_DATE AND EPY.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EPY.ELIG_PYRL_PRTE_ID
, EPY.EFFECTIVE_START_DATE
, EPY.EFFECTIVE_END_DATE
, EPY.BUSINESS_GROUP_ID
, EPY.PAYROLL_ID
, EPY.EXCLD_FLAG
, EPY.ORDR_NUM
, EPY.ELIGY_PRFL_ID
, EPY.CRITERIA_SCORE
, EPY.CRITERIA_WEIGHT
, EPY.EPY_ATTRIBUTE_CATEGORY
, EPY.EPY_ATTRIBUTE1
, EPY.EPY_ATTRIBUTE2
, EPY.EPY_ATTRIBUTE3
, EPY.EPY_ATTRIBUTE4
, EPY.EPY_ATTRIBUTE5
, EPY.EPY_ATTRIBUTE6
, EPY.EPY_ATTRIBUTE7
, EPY.EPY_ATTRIBUTE8
, EPY.EPY_ATTRIBUTE9
, EPY.EPY_ATTRIBUTE10
, EPY.EPY_ATTRIBUTE11
, EPY.EPY_ATTRIBUTE12
, EPY.EPY_ATTRIBUTE13
, EPY.EPY_ATTRIBUTE14
, EPY.EPY_ATTRIBUTE15
, EPY.EPY_ATTRIBUTE16
, EPY.EPY_ATTRIBUTE17
, EPY.EPY_ATTRIBUTE18
, EPY.EPY_ATTRIBUTE19
, EPY.EPY_ATTRIBUTE20
, EPY.EPY_ATTRIBUTE21
, EPY.EPY_ATTRIBUTE22
, EPY.EPY_ATTRIBUTE23
, EPY.EPY_ATTRIBUTE24
, EPY.EPY_ATTRIBUTE25
, EPY.EPY_ATTRIBUTE26
, EPY.EPY_ATTRIBUTE27
, EPY.EPY_ATTRIBUTE28
, EPY.EPY_ATTRIBUTE29
, EPY.EPY_ATTRIBUTE30
, EPY.LAST_UPDATE_DATE
, EPY.LAST_UPDATED_BY
, EPY.LAST_UPDATE_LOGIN
, EPY.CREATED_BY
, EPY.CREATION_DATE
, EPY.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PYRL_PRTE_F EPY
WHERE TRUNC(SYSDATE) BETWEEN EPY.EFFECTIVE_START_DATE
AND EPY.EFFECTIVE_END_DATE