VIEW: APPS.BEN_ELIG_AGE_PRTE_V

Source

View Text - Preformatted

SELECT EAP.ROWID ROW_ID , EAP.ELIG_AGE_PRTE_ID , EAP.EFFECTIVE_START_DATE , EAP.EFFECTIVE_END_DATE , EAP.BUSINESS_GROUP_ID , EAP.AGE_FCTR_ID , EAP.ELIGY_PRFL_ID , EAP.ORDR_NUM , EAP.EXCLD_FLAG , EAP.CRITERIA_SCORE , EAP.CRITERIA_WEIGHT , EAP.EAP_ATTRIBUTE_CATEGORY , EAP.EAP_ATTRIBUTE1 , EAP.EAP_ATTRIBUTE2 , EAP.EAP_ATTRIBUTE3 , EAP.EAP_ATTRIBUTE4 , EAP.EAP_ATTRIBUTE5 , EAP.EAP_ATTRIBUTE6 , EAP.EAP_ATTRIBUTE7 , EAP.EAP_ATTRIBUTE8 , EAP.EAP_ATTRIBUTE9 , EAP.EAP_ATTRIBUTE10 , EAP.EAP_ATTRIBUTE11 , EAP.EAP_ATTRIBUTE12 , EAP.EAP_ATTRIBUTE13 , EAP.EAP_ATTRIBUTE14 , EAP.EAP_ATTRIBUTE15 , EAP.EAP_ATTRIBUTE16 , EAP.EAP_ATTRIBUTE17 , EAP.EAP_ATTRIBUTE18 , EAP.EAP_ATTRIBUTE19 , EAP.EAP_ATTRIBUTE20 , EAP.EAP_ATTRIBUTE21 , EAP.EAP_ATTRIBUTE22 , EAP.EAP_ATTRIBUTE23 , EAP.EAP_ATTRIBUTE24 , EAP.EAP_ATTRIBUTE25 , EAP.EAP_ATTRIBUTE26 , EAP.EAP_ATTRIBUTE27 , EAP.EAP_ATTRIBUTE28 , EAP.EAP_ATTRIBUTE29 , EAP.EAP_ATTRIBUTE30 , EAP.LAST_UPDATE_DATE , EAP.LAST_UPDATED_BY , EAP.LAST_UPDATE_LOGIN , EAP.CREATED_BY , EAP.CREATION_DATE , EAP.OBJECT_VERSION_NUMBER FROM BEN_ELIG_AGE_PRTE_F EAP, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN EAP.EFFECTIVE_START_DATE AND EAP.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EAP.ROWID ROW_ID
, EAP.ELIG_AGE_PRTE_ID
, EAP.EFFECTIVE_START_DATE
, EAP.EFFECTIVE_END_DATE
, EAP.BUSINESS_GROUP_ID
, EAP.AGE_FCTR_ID
, EAP.ELIGY_PRFL_ID
, EAP.ORDR_NUM
, EAP.EXCLD_FLAG
, EAP.CRITERIA_SCORE
, EAP.CRITERIA_WEIGHT
, EAP.EAP_ATTRIBUTE_CATEGORY
, EAP.EAP_ATTRIBUTE1
, EAP.EAP_ATTRIBUTE2
, EAP.EAP_ATTRIBUTE3
, EAP.EAP_ATTRIBUTE4
, EAP.EAP_ATTRIBUTE5
, EAP.EAP_ATTRIBUTE6
, EAP.EAP_ATTRIBUTE7
, EAP.EAP_ATTRIBUTE8
, EAP.EAP_ATTRIBUTE9
, EAP.EAP_ATTRIBUTE10
, EAP.EAP_ATTRIBUTE11
, EAP.EAP_ATTRIBUTE12
, EAP.EAP_ATTRIBUTE13
, EAP.EAP_ATTRIBUTE14
, EAP.EAP_ATTRIBUTE15
, EAP.EAP_ATTRIBUTE16
, EAP.EAP_ATTRIBUTE17
, EAP.EAP_ATTRIBUTE18
, EAP.EAP_ATTRIBUTE19
, EAP.EAP_ATTRIBUTE20
, EAP.EAP_ATTRIBUTE21
, EAP.EAP_ATTRIBUTE22
, EAP.EAP_ATTRIBUTE23
, EAP.EAP_ATTRIBUTE24
, EAP.EAP_ATTRIBUTE25
, EAP.EAP_ATTRIBUTE26
, EAP.EAP_ATTRIBUTE27
, EAP.EAP_ATTRIBUTE28
, EAP.EAP_ATTRIBUTE29
, EAP.EAP_ATTRIBUTE30
, EAP.LAST_UPDATE_DATE
, EAP.LAST_UPDATED_BY
, EAP.LAST_UPDATE_LOGIN
, EAP.CREATED_BY
, EAP.CREATION_DATE
, EAP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_AGE_PRTE_F EAP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EAP.EFFECTIVE_START_DATE
AND EAP.EFFECTIVE_END_DATE