eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_BNFTS_BAL

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

View Text

SELECT 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
WHERE BNB.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND BNB.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
BNFTS_BAL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
NAME
BNFTS_BAL_USG_CD
BNFTS_BAL_DESC
UOM
NNMNTRY_UOM
BUSINESS_GROUP_ID
BNB_ATTRIBUTE_CATEGORY
BNB_ATTRIBUTE1
BNB_ATTRIBUTE2
BNB_ATTRIBUTE3
BNB_ATTRIBUTE4
BNB_ATTRIBUTE5
BNB_ATTRIBUTE6
BNB_ATTRIBUTE7
BNB_ATTRIBUTE8
BNB_ATTRIBUTE9
BNB_ATTRIBUTE10
BNB_ATTRIBUTE11
BNB_ATTRIBUTE12
BNB_ATTRIBUTE13
BNB_ATTRIBUTE14
BNB_ATTRIBUTE15
BNB_ATTRIBUTE16
BNB_ATTRIBUTE17
BNB_ATTRIBUTE18
BNB_ATTRIBUTE19
BNB_ATTRIBUTE20
BNB_ATTRIBUTE21
BNB_ATTRIBUTE22
BNB_ATTRIBUTE23
BNB_ATTRIBUTE24
BNB_ATTRIBUTE25
BNB_ATTRIBUTE26
BNB_ATTRIBUTE27
BNB_ATTRIBUTE28
BNB_ATTRIBUTE29
BNB_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER