VIEW: APPS.BEN_ELIG_JOB_PRTE_V

Source

View Text - Preformatted

SELECT EJP.ROWID ROW_ID , EJP.ELIG_JOB_PRTE_ID , EJP.EFFECTIVE_START_DATE , EJP.EFFECTIVE_END_DATE , EJP.ORDR_NUM , EJP.EXCLD_FLAG , EJP.JOB_ID , EJP.ELIGY_PRFL_ID , EJP.BUSINESS_GROUP_ID , EJP.CRITERIA_SCORE , EJP.CRITERIA_WEIGHT , EJP.EJP_ATTRIBUTE_CATEGORY , EJP.EJP_ATTRIBUTE1 , EJP.EJP_ATTRIBUTE2 , EJP.EJP_ATTRIBUTE3 , EJP.EJP_ATTRIBUTE4 , EJP.EJP_ATTRIBUTE5 , EJP.EJP_ATTRIBUTE6 , EJP.EJP_ATTRIBUTE7 , EJP.EJP_ATTRIBUTE8 , EJP.EJP_ATTRIBUTE9 , EJP.EJP_ATTRIBUTE10 , EJP.EJP_ATTRIBUTE11 , EJP.EJP_ATTRIBUTE12 , EJP.EJP_ATTRIBUTE13 , EJP.EJP_ATTRIBUTE14 , EJP.EJP_ATTRIBUTE15 , EJP.EJP_ATTRIBUTE16 , EJP.EJP_ATTRIBUTE17 , EJP.EJP_ATTRIBUTE18 , EJP.EJP_ATTRIBUTE19 , EJP.EJP_ATTRIBUTE20 , EJP.EJP_ATTRIBUTE21 , EJP.EJP_ATTRIBUTE22 , EJP.EJP_ATTRIBUTE23 , EJP.EJP_ATTRIBUTE24 , EJP.EJP_ATTRIBUTE25 , EJP.EJP_ATTRIBUTE26 , EJP.EJP_ATTRIBUTE27 , EJP.EJP_ATTRIBUTE28 , EJP.EJP_ATTRIBUTE29 , EJP.EJP_ATTRIBUTE30 , EJP.LAST_UPDATE_DATE , EJP.LAST_UPDATED_BY , EJP.LAST_UPDATE_LOGIN , EJP.CREATED_BY , EJP.CREATION_DATE , EJP.OBJECT_VERSION_NUMBER FROM BEN_ELIG_JOB_PRTE_F EJP, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN EJP.EFFECTIVE_START_DATE AND EJP.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT EJP.ROWID ROW_ID
, EJP.ELIG_JOB_PRTE_ID
, EJP.EFFECTIVE_START_DATE
, EJP.EFFECTIVE_END_DATE
, EJP.ORDR_NUM
, EJP.EXCLD_FLAG
, EJP.JOB_ID
, EJP.ELIGY_PRFL_ID
, EJP.BUSINESS_GROUP_ID
, EJP.CRITERIA_SCORE
, EJP.CRITERIA_WEIGHT
, EJP.EJP_ATTRIBUTE_CATEGORY
, EJP.EJP_ATTRIBUTE1
, EJP.EJP_ATTRIBUTE2
, EJP.EJP_ATTRIBUTE3
, EJP.EJP_ATTRIBUTE4
, EJP.EJP_ATTRIBUTE5
, EJP.EJP_ATTRIBUTE6
, EJP.EJP_ATTRIBUTE7
, EJP.EJP_ATTRIBUTE8
, EJP.EJP_ATTRIBUTE9
, EJP.EJP_ATTRIBUTE10
, EJP.EJP_ATTRIBUTE11
, EJP.EJP_ATTRIBUTE12
, EJP.EJP_ATTRIBUTE13
, EJP.EJP_ATTRIBUTE14
, EJP.EJP_ATTRIBUTE15
, EJP.EJP_ATTRIBUTE16
, EJP.EJP_ATTRIBUTE17
, EJP.EJP_ATTRIBUTE18
, EJP.EJP_ATTRIBUTE19
, EJP.EJP_ATTRIBUTE20
, EJP.EJP_ATTRIBUTE21
, EJP.EJP_ATTRIBUTE22
, EJP.EJP_ATTRIBUTE23
, EJP.EJP_ATTRIBUTE24
, EJP.EJP_ATTRIBUTE25
, EJP.EJP_ATTRIBUTE26
, EJP.EJP_ATTRIBUTE27
, EJP.EJP_ATTRIBUTE28
, EJP.EJP_ATTRIBUTE29
, EJP.EJP_ATTRIBUTE30
, EJP.LAST_UPDATE_DATE
, EJP.LAST_UPDATED_BY
, EJP.LAST_UPDATE_LOGIN
, EJP.CREATED_BY
, EJP.CREATION_DATE
, EJP.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_JOB_PRTE_F EJP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN EJP.EFFECTIVE_START_DATE
AND EJP.EFFECTIVE_END_DATE