Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_GRADE_RT_V |
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