View: BEN_BNFTS_BAL_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted - Retrofitted
Implementation/DBA Data:	APPS.BEN_BNFTS_BAL_V

View Text

SELECT BNB.ROWID ROW_ID
, BNB.BNFTS_BAL_ID
, BNB.EFFECTIVE_START_DATE
, BNB.EFFECTIVE_END_DATE
, BNB.NAME
, BNB.BNFTS_BAL_USG_CD
, BNB.BNFTS_BAL_DESC
, BNB.UOM
, BNB.NNMNTRY_UOM
, BNB.BUSINESS_GROUP_ID
, BNB.BNB_ATTRIBUTE_CATEGORY
, BNB.BNB_ATTRIBUTE1
, BNB.BNB_ATTRIBUTE2
, BNB.BNB_ATTRIBUTE3
, BNB.BNB_ATTRIBUTE4
, BNB.BNB_ATTRIBUTE5
, BNB.BNB_ATTRIBUTE6
, BNB.BNB_ATTRIBUTE7
, BNB.BNB_ATTRIBUTE8
, BNB.BNB_ATTRIBUTE9
, BNB.BNB_ATTRIBUTE10
, BNB.BNB_ATTRIBUTE11
, BNB.BNB_ATTRIBUTE12
, BNB.BNB_ATTRIBUTE13
, BNB.BNB_ATTRIBUTE14
, BNB.BNB_ATTRIBUTE15
, BNB.BNB_ATTRIBUTE16
, BNB.BNB_ATTRIBUTE17
, BNB.BNB_ATTRIBUTE18
, BNB.BNB_ATTRIBUTE19
, BNB.BNB_ATTRIBUTE20
, BNB.BNB_ATTRIBUTE21
, BNB.BNB_ATTRIBUTE22
, BNB.BNB_ATTRIBUTE23
, BNB.BNB_ATTRIBUTE24
, BNB.BNB_ATTRIBUTE25
, BNB.BNB_ATTRIBUTE26
, BNB.BNB_ATTRIBUTE27
, BNB.BNB_ATTRIBUTE28
, BNB.BNB_ATTRIBUTE29
, BNB.BNB_ATTRIBUTE30
, BNB.LAST_UPDATE_DATE
, BNB.LAST_UPDATED_BY
, BNB.LAST_UPDATE_LOGIN
, BNB.CREATED_BY
, BNB.CREATION_DATE
, BNB.OBJECT_VERSION_NUMBER
FROM BEN_BNFTS_BAL_F BNB
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN BNB.EFFECTIVE_START_DATE
AND BNB.EFFECTIVE_END_DATE

Columns