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.BEN_PER_BNFTS_BAL_F#

Source

View Text - Preformatted


select PER_BNFTS_BAL_ID PER_BNFTS_BAL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BNFTS_BAL_ID BNFTS_BAL_ID, PERSON_ID PERSON_ID, PBB_ATTRIBUTE_CATEGORY PBB_ATTRIBUTE_CATEGORY, PBB_ATTRIBUTE1 PBB_ATTRIBUTE1, PBB_ATTRIBUTE2 PBB_ATTRIBUTE2, PBB_ATTRIBUTE3 PBB_ATTRIBUTE3, PBB_ATTRIBUTE4 PBB_ATTRIBUTE4, PBB_ATTRIBUTE5 PBB_ATTRIBUTE5, PBB_ATTRIBUTE6 PBB_ATTRIBUTE6, PBB_ATTRIBUTE7 PBB_ATTRIBUTE7, PBB_ATTRIBUTE8 PBB_ATTRIBUTE8, PBB_ATTRIBUTE9 PBB_ATTRIBUTE9, PBB_ATTRIBUTE10 PBB_ATTRIBUTE10, PBB_ATTRIBUTE11 PBB_ATTRIBUTE11, PBB_ATTRIBUTE12 PBB_ATTRIBUTE12, PBB_ATTRIBUTE13 PBB_ATTRIBUTE13, PBB_ATTRIBUTE14 PBB_ATTRIBUTE14, PBB_ATTRIBUTE15 PBB_ATTRIBUTE15, PBB_ATTRIBUTE16 PBB_ATTRIBUTE16, PBB_ATTRIBUTE17 PBB_ATTRIBUTE17, PBB_ATTRIBUTE18 PBB_ATTRIBUTE18, PBB_ATTRIBUTE19 PBB_ATTRIBUTE19, PBB_ATTRIBUTE20 PBB_ATTRIBUTE20, PBB_ATTRIBUTE21 PBB_ATTRIBUTE21, PBB_ATTRIBUTE22 PBB_ATTRIBUTE22, PBB_ATTRIBUTE23 PBB_ATTRIBUTE23, PBB_ATTRIBUTE24 PBB_ATTRIBUTE24, PBB_ATTRIBUTE25 PBB_ATTRIBUTE25, PBB_ATTRIBUTE26 PBB_ATTRIBUTE26, PBB_ATTRIBUTE27 PBB_ATTRIBUTE27, PBB_ATTRIBUTE28 PBB_ATTRIBUTE28, PBB_ATTRIBUTE29 PBB_ATTRIBUTE29, PBB_ATTRIBUTE30 PBB_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VAL VAL from "BEN"."BEN_PER_BNFTS_BAL_F"

View Text - HTML Formatted

SELECT PER_BNFTS_BAL_ID PER_BNFTS_BAL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BNFTS_BAL_ID BNFTS_BAL_ID
, PERSON_ID PERSON_ID
, PBB_ATTRIBUTE_CATEGORY PBB_ATTRIBUTE_CATEGORY
, PBB_ATTRIBUTE1 PBB_ATTRIBUTE1
, PBB_ATTRIBUTE2 PBB_ATTRIBUTE2
, PBB_ATTRIBUTE3 PBB_ATTRIBUTE3
, PBB_ATTRIBUTE4 PBB_ATTRIBUTE4
, PBB_ATTRIBUTE5 PBB_ATTRIBUTE5
, PBB_ATTRIBUTE6 PBB_ATTRIBUTE6
, PBB_ATTRIBUTE7 PBB_ATTRIBUTE7
, PBB_ATTRIBUTE8 PBB_ATTRIBUTE8
, PBB_ATTRIBUTE9 PBB_ATTRIBUTE9
, PBB_ATTRIBUTE10 PBB_ATTRIBUTE10
, PBB_ATTRIBUTE11 PBB_ATTRIBUTE11
, PBB_ATTRIBUTE12 PBB_ATTRIBUTE12
, PBB_ATTRIBUTE13 PBB_ATTRIBUTE13
, PBB_ATTRIBUTE14 PBB_ATTRIBUTE14
, PBB_ATTRIBUTE15 PBB_ATTRIBUTE15
, PBB_ATTRIBUTE16 PBB_ATTRIBUTE16
, PBB_ATTRIBUTE17 PBB_ATTRIBUTE17
, PBB_ATTRIBUTE18 PBB_ATTRIBUTE18
, PBB_ATTRIBUTE19 PBB_ATTRIBUTE19
, PBB_ATTRIBUTE20 PBB_ATTRIBUTE20
, PBB_ATTRIBUTE21 PBB_ATTRIBUTE21
, PBB_ATTRIBUTE22 PBB_ATTRIBUTE22
, PBB_ATTRIBUTE23 PBB_ATTRIBUTE23
, PBB_ATTRIBUTE24 PBB_ATTRIBUTE24
, PBB_ATTRIBUTE25 PBB_ATTRIBUTE25
, PBB_ATTRIBUTE26 PBB_ATTRIBUTE26
, PBB_ATTRIBUTE27 PBB_ATTRIBUTE27
, PBB_ATTRIBUTE28 PBB_ATTRIBUTE28
, PBB_ATTRIBUTE29 PBB_ATTRIBUTE29
, PBB_ATTRIBUTE30 PBB_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VAL VAL
FROM "BEN"."BEN_PER_BNFTS_BAL_F"