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