VIEW: APPS.BEN_GRADE_RT_V

Source

View Text - Preformatted

SELECT GRR.ROWID ROW_ID , GRR.GRADE_RT_ID , GRR.EFFECTIVE_START_DATE , GRR.EFFECTIVE_END_DATE , GRR.BUSINESS_GROUP_ID , GRR.VRBL_RT_PRFL_ID , GRR.GRADE_ID , GRR.ORDR_NUM , GRR.EXCLD_FLAG , GRR.GRR_ATTRIBUTE_CATEGORY , GRR.GRR_ATTRIBUTE1 , GRR.GRR_ATTRIBUTE2 , GRR.GRR_ATTRIBUTE3 , GRR.GRR_ATTRIBUTE4 , GRR.GRR_ATTRIBUTE5 , GRR.GRR_ATTRIBUTE6 , GRR.GRR_ATTRIBUTE7 , GRR.GRR_ATTRIBUTE8 , GRR.GRR_ATTRIBUTE9 , GRR.GRR_ATTRIBUTE10 , GRR.GRR_ATTRIBUTE11 , GRR.GRR_ATTRIBUTE12 , GRR.GRR_ATTRIBUTE13 , GRR.GRR_ATTRIBUTE14 , GRR.GRR_ATTRIBUTE15 , GRR.GRR_ATTRIBUTE16 , GRR.GRR_ATTRIBUTE17 , GRR.GRR_ATTRIBUTE18 , GRR.GRR_ATTRIBUTE19 , GRR.GRR_ATTRIBUTE20 , GRR.GRR_ATTRIBUTE21 , GRR.GRR_ATTRIBUTE22 , GRR.GRR_ATTRIBUTE23 , GRR.GRR_ATTRIBUTE24 , GRR.GRR_ATTRIBUTE25 , GRR.GRR_ATTRIBUTE26 , GRR.GRR_ATTRIBUTE27 , GRR.GRR_ATTRIBUTE28 , GRR.GRR_ATTRIBUTE29 , GRR.GRR_ATTRIBUTE30 , GRR.LAST_UPDATE_DATE , GRR.LAST_UPDATED_BY , GRR.LAST_UPDATE_LOGIN , GRR.CREATED_BY , GRR.CREATION_DATE , GRR.OBJECT_VERSION_NUMBER FROM BEN_GRADE_RT_F GRR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN GRR.EFFECTIVE_START_DATE AND GRR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT GRR.ROWID ROW_ID
, GRR.GRADE_RT_ID
, GRR.EFFECTIVE_START_DATE
, GRR.EFFECTIVE_END_DATE
, GRR.BUSINESS_GROUP_ID
, GRR.VRBL_RT_PRFL_ID
, GRR.GRADE_ID
, GRR.ORDR_NUM
, GRR.EXCLD_FLAG
, GRR.GRR_ATTRIBUTE_CATEGORY
, GRR.GRR_ATTRIBUTE1
, GRR.GRR_ATTRIBUTE2
, GRR.GRR_ATTRIBUTE3
, GRR.GRR_ATTRIBUTE4
, GRR.GRR_ATTRIBUTE5
, GRR.GRR_ATTRIBUTE6
, GRR.GRR_ATTRIBUTE7
, GRR.GRR_ATTRIBUTE8
, GRR.GRR_ATTRIBUTE9
, GRR.GRR_ATTRIBUTE10
, GRR.GRR_ATTRIBUTE11
, GRR.GRR_ATTRIBUTE12
, GRR.GRR_ATTRIBUTE13
, GRR.GRR_ATTRIBUTE14
, GRR.GRR_ATTRIBUTE15
, GRR.GRR_ATTRIBUTE16
, GRR.GRR_ATTRIBUTE17
, GRR.GRR_ATTRIBUTE18
, GRR.GRR_ATTRIBUTE19
, GRR.GRR_ATTRIBUTE20
, GRR.GRR_ATTRIBUTE21
, GRR.GRR_ATTRIBUTE22
, GRR.GRR_ATTRIBUTE23
, GRR.GRR_ATTRIBUTE24
, GRR.GRR_ATTRIBUTE25
, GRR.GRR_ATTRIBUTE26
, GRR.GRR_ATTRIBUTE27
, GRR.GRR_ATTRIBUTE28
, GRR.GRR_ATTRIBUTE29
, GRR.GRR_ATTRIBUTE30
, GRR.LAST_UPDATE_DATE
, GRR.LAST_UPDATED_BY
, GRR.LAST_UPDATE_LOGIN
, GRR.CREATED_BY
, GRR.CREATION_DATE
, GRR.OBJECT_VERSION_NUMBER
FROM BEN_GRADE_RT_F GRR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN GRR.EFFECTIVE_START_DATE
AND GRR.EFFECTIVE_END_DATE