VIEW: APPS.BEN_ELIG_PER_TYP_PRTE_V

Source

View Text - Preformatted

SELECT EPT.ROWID ROW_ID , EPT.ELIG_PER_TYP_PRTE_ID , EPT.EFFECTIVE_START_DATE , EPT.EFFECTIVE_END_DATE , EPT.BUSINESS_GROUP_ID , EPT.ELIGY_PRFL_ID , EPT.PER_TYP_CD , EPT.PERSON_TYPE_ID , EPT.ORDR_NUM , EPT.EXCLD_FLAG , EPT.CRITERIA_SCORE , EPT.CRITERIA_WEIGHT , EPT.EPT_ATTRIBUTE_CATEGORY , EPT.EPT_ATTRIBUTE1 , EPT.EPT_ATTRIBUTE2 , EPT.EPT_ATTRIBUTE3 , EPT.EPT_ATTRIBUTE4 , EPT.EPT_ATTRIBUTE5 , EPT.EPT_ATTRIBUTE6 , EPT.EPT_ATTRIBUTE7 , EPT.EPT_ATTRIBUTE8 , EPT.EPT_ATTRIBUTE9 , EPT.EPT_ATTRIBUTE10 , EPT.EPT_ATTRIBUTE11 , EPT.EPT_ATTRIBUTE12 , EPT.EPT_ATTRIBUTE13 , EPT.EPT_ATTRIBUTE14 , EPT.EPT_ATTRIBUTE15 , EPT.EPT_ATTRIBUTE16 , EPT.EPT_ATTRIBUTE17 , EPT.EPT_ATTRIBUTE18 , EPT.EPT_ATTRIBUTE19 , EPT.EPT_ATTRIBUTE20 , EPT.EPT_ATTRIBUTE21 , EPT.EPT_ATTRIBUTE22 , EPT.EPT_ATTRIBUTE23 , EPT.EPT_ATTRIBUTE24 , EPT.EPT_ATTRIBUTE25 , EPT.EPT_ATTRIBUTE26 , EPT.EPT_ATTRIBUTE27 , EPT.EPT_ATTRIBUTE28 , EPT.EPT_ATTRIBUTE29 , EPT.EPT_ATTRIBUTE30 , EPT.LAST_UPDATE_DATE , EPT.LAST_UPDATED_BY , EPT.LAST_UPDATE_LOGIN , EPT.CREATED_BY , EPT.CREATION_DATE , EPT.OBJECT_VERSION_NUMBER FROM BEN_ELIG_PER_TYP_PRTE_F EPT, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN EPT.EFFECTIVE_START_DATE AND EPT.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EPT.ROWID ROW_ID
, EPT.ELIG_PER_TYP_PRTE_ID
, EPT.EFFECTIVE_START_DATE
, EPT.EFFECTIVE_END_DATE
, EPT.BUSINESS_GROUP_ID
, EPT.ELIGY_PRFL_ID
, EPT.PER_TYP_CD
, EPT.PERSON_TYPE_ID
, EPT.ORDR_NUM
, EPT.EXCLD_FLAG
, EPT.CRITERIA_SCORE
, EPT.CRITERIA_WEIGHT
, EPT.EPT_ATTRIBUTE_CATEGORY
, EPT.EPT_ATTRIBUTE1
, EPT.EPT_ATTRIBUTE2
, EPT.EPT_ATTRIBUTE3
, EPT.EPT_ATTRIBUTE4
, EPT.EPT_ATTRIBUTE5
, EPT.EPT_ATTRIBUTE6
, EPT.EPT_ATTRIBUTE7
, EPT.EPT_ATTRIBUTE8
, EPT.EPT_ATTRIBUTE9
, EPT.EPT_ATTRIBUTE10
, EPT.EPT_ATTRIBUTE11
, EPT.EPT_ATTRIBUTE12
, EPT.EPT_ATTRIBUTE13
, EPT.EPT_ATTRIBUTE14
, EPT.EPT_ATTRIBUTE15
, EPT.EPT_ATTRIBUTE16
, EPT.EPT_ATTRIBUTE17
, EPT.EPT_ATTRIBUTE18
, EPT.EPT_ATTRIBUTE19
, EPT.EPT_ATTRIBUTE20
, EPT.EPT_ATTRIBUTE21
, EPT.EPT_ATTRIBUTE22
, EPT.EPT_ATTRIBUTE23
, EPT.EPT_ATTRIBUTE24
, EPT.EPT_ATTRIBUTE25
, EPT.EPT_ATTRIBUTE26
, EPT.EPT_ATTRIBUTE27
, EPT.EPT_ATTRIBUTE28
, EPT.EPT_ATTRIBUTE29
, EPT.EPT_ATTRIBUTE30
, EPT.LAST_UPDATE_DATE
, EPT.LAST_UPDATED_BY
, EPT.LAST_UPDATE_LOGIN
, EPT.CREATED_BY
, EPT.CREATION_DATE
, EPT.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PER_TYP_PRTE_F EPT
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EPT.EFFECTIVE_START_DATE
AND EPT.EFFECTIVE_END_DATE