VIEW: APPS.BEN_BENFTS_GRP_RT_V

Source

View Text - Preformatted

SELECT BRG.ROWID ROW_ID , BRG.BENFTS_GRP_RT_ID , BRG.EFFECTIVE_START_DATE , BRG.EFFECTIVE_END_DATE , BRG.BUSINESS_GROUP_ID , BRG.VRBL_RT_PRFL_ID , BRG.BENFTS_GRP_ID , BRG.EXCLD_FLAG , BRG.ORDR_NUM , BRG.BRG_ATTRIBUTE_CATEGORY , BRG.BRG_ATTRIBUTE1 , BRG.BRG_ATTRIBUTE2 , BRG.BRG_ATTRIBUTE3 , BRG.BRG_ATTRIBUTE4 , BRG.BRG_ATTRIBUTE5 , BRG.BRG_ATTRIBUTE6 , BRG.BRG_ATTRIBUTE7 , BRG.BRG_ATTRIBUTE8 , BRG.BRG_ATTRIBUTE9 , BRG.BRG_ATTRIBUTE10 , BRG.BRG_ATTRIBUTE11 , BRG.BRG_ATTRIBUTE12 , BRG.BRG_ATTRIBUTE13 , BRG.BRG_ATTRIBUTE14 , BRG.BRG_ATTRIBUTE15 , BRG.BRG_ATTRIBUTE16 , BRG.BRG_ATTRIBUTE17 , BRG.BRG_ATTRIBUTE18 , BRG.BRG_ATTRIBUTE19 , BRG.BRG_ATTRIBUTE20 , BRG.BRG_ATTRIBUTE21 , BRG.BRG_ATTRIBUTE22 , BRG.BRG_ATTRIBUTE23 , BRG.BRG_ATTRIBUTE24 , BRG.BRG_ATTRIBUTE25 , BRG.BRG_ATTRIBUTE26 , BRG.BRG_ATTRIBUTE27 , BRG.BRG_ATTRIBUTE28 , BRG.BRG_ATTRIBUTE29 , BRG.BRG_ATTRIBUTE30 , BRG.LAST_UPDATE_DATE , BRG.LAST_UPDATED_BY , BRG.LAST_UPDATE_LOGIN , BRG.CREATED_BY , BRG.CREATION_DATE , BRG.OBJECT_VERSION_NUMBER FROM BEN_BENFTS_GRP_RT_F BRG, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN BRG.EFFECTIVE_START_DATE AND BRG.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT BRG.ROWID ROW_ID
, BRG.BENFTS_GRP_RT_ID
, BRG.EFFECTIVE_START_DATE
, BRG.EFFECTIVE_END_DATE
, BRG.BUSINESS_GROUP_ID
, BRG.VRBL_RT_PRFL_ID
, BRG.BENFTS_GRP_ID
, BRG.EXCLD_FLAG
, BRG.ORDR_NUM
, BRG.BRG_ATTRIBUTE_CATEGORY
, BRG.BRG_ATTRIBUTE1
, BRG.BRG_ATTRIBUTE2
, BRG.BRG_ATTRIBUTE3
, BRG.BRG_ATTRIBUTE4
, BRG.BRG_ATTRIBUTE5
, BRG.BRG_ATTRIBUTE6
, BRG.BRG_ATTRIBUTE7
, BRG.BRG_ATTRIBUTE8
, BRG.BRG_ATTRIBUTE9
, BRG.BRG_ATTRIBUTE10
, BRG.BRG_ATTRIBUTE11
, BRG.BRG_ATTRIBUTE12
, BRG.BRG_ATTRIBUTE13
, BRG.BRG_ATTRIBUTE14
, BRG.BRG_ATTRIBUTE15
, BRG.BRG_ATTRIBUTE16
, BRG.BRG_ATTRIBUTE17
, BRG.BRG_ATTRIBUTE18
, BRG.BRG_ATTRIBUTE19
, BRG.BRG_ATTRIBUTE20
, BRG.BRG_ATTRIBUTE21
, BRG.BRG_ATTRIBUTE22
, BRG.BRG_ATTRIBUTE23
, BRG.BRG_ATTRIBUTE24
, BRG.BRG_ATTRIBUTE25
, BRG.BRG_ATTRIBUTE26
, BRG.BRG_ATTRIBUTE27
, BRG.BRG_ATTRIBUTE28
, BRG.BRG_ATTRIBUTE29
, BRG.BRG_ATTRIBUTE30
, BRG.LAST_UPDATE_DATE
, BRG.LAST_UPDATED_BY
, BRG.LAST_UPDATE_LOGIN
, BRG.CREATED_BY
, BRG.CREATION_DATE
, BRG.OBJECT_VERSION_NUMBER
FROM BEN_BENFTS_GRP_RT_F BRG
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN BRG.EFFECTIVE_START_DATE
AND BRG.EFFECTIVE_END_DATE