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_PTD_BAL_TYP_F#

Source

View Text - Preformatted


select PTD_BAL_TYP_ID PTD_BAL_TYP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PTD_LMT_ID PTD_LMT_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, PBY_ATTRIBUTE_CATEGORY PBY_ATTRIBUTE_CATEGORY, PBY_ATTRIBUTE1 PBY_ATTRIBUTE1, PBY_ATTRIBUTE2 PBY_ATTRIBUTE2, PBY_ATTRIBUTE3 PBY_ATTRIBUTE3, PBY_ATTRIBUTE4 PBY_ATTRIBUTE4, PBY_ATTRIBUTE5 PBY_ATTRIBUTE5, PBY_ATTRIBUTE6 PBY_ATTRIBUTE6, PBY_ATTRIBUTE7 PBY_ATTRIBUTE7, PBY_ATTRIBUTE8 PBY_ATTRIBUTE8, PBY_ATTRIBUTE9 PBY_ATTRIBUTE9, PBY_ATTRIBUTE10 PBY_ATTRIBUTE10, PBY_ATTRIBUTE11 PBY_ATTRIBUTE11, PBY_ATTRIBUTE12 PBY_ATTRIBUTE12, PBY_ATTRIBUTE13 PBY_ATTRIBUTE13, PBY_ATTRIBUTE14 PBY_ATTRIBUTE14, PBY_ATTRIBUTE15 PBY_ATTRIBUTE15, PBY_ATTRIBUTE16 PBY_ATTRIBUTE16, PBY_ATTRIBUTE17 PBY_ATTRIBUTE17, PBY_ATTRIBUTE18 PBY_ATTRIBUTE18, PBY_ATTRIBUTE19 PBY_ATTRIBUTE19, PBY_ATTRIBUTE20 PBY_ATTRIBUTE20, PBY_ATTRIBUTE21 PBY_ATTRIBUTE21, PBY_ATTRIBUTE22 PBY_ATTRIBUTE22, PBY_ATTRIBUTE23 PBY_ATTRIBUTE23, PBY_ATTRIBUTE24 PBY_ATTRIBUTE24, PBY_ATTRIBUTE25 PBY_ATTRIBUTE25, PBY_ATTRIBUTE26 PBY_ATTRIBUTE26, PBY_ATTRIBUTE27 PBY_ATTRIBUTE27, PBY_ATTRIBUTE28 PBY_ATTRIBUTE28, PBY_ATTRIBUTE29 PBY_ATTRIBUTE29, PBY_ATTRIBUTE30 PBY_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, CLG_AMT CLG_AMT, FLR_AMT FLR_AMT from "BEN"."BEN_PTD_BAL_TYP_F"

View Text - HTML Formatted

SELECT PTD_BAL_TYP_ID PTD_BAL_TYP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PTD_LMT_ID PTD_LMT_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, PBY_ATTRIBUTE_CATEGORY PBY_ATTRIBUTE_CATEGORY
, PBY_ATTRIBUTE1 PBY_ATTRIBUTE1
, PBY_ATTRIBUTE2 PBY_ATTRIBUTE2
, PBY_ATTRIBUTE3 PBY_ATTRIBUTE3
, PBY_ATTRIBUTE4 PBY_ATTRIBUTE4
, PBY_ATTRIBUTE5 PBY_ATTRIBUTE5
, PBY_ATTRIBUTE6 PBY_ATTRIBUTE6
, PBY_ATTRIBUTE7 PBY_ATTRIBUTE7
, PBY_ATTRIBUTE8 PBY_ATTRIBUTE8
, PBY_ATTRIBUTE9 PBY_ATTRIBUTE9
, PBY_ATTRIBUTE10 PBY_ATTRIBUTE10
, PBY_ATTRIBUTE11 PBY_ATTRIBUTE11
, PBY_ATTRIBUTE12 PBY_ATTRIBUTE12
, PBY_ATTRIBUTE13 PBY_ATTRIBUTE13
, PBY_ATTRIBUTE14 PBY_ATTRIBUTE14
, PBY_ATTRIBUTE15 PBY_ATTRIBUTE15
, PBY_ATTRIBUTE16 PBY_ATTRIBUTE16
, PBY_ATTRIBUTE17 PBY_ATTRIBUTE17
, PBY_ATTRIBUTE18 PBY_ATTRIBUTE18
, PBY_ATTRIBUTE19 PBY_ATTRIBUTE19
, PBY_ATTRIBUTE20 PBY_ATTRIBUTE20
, PBY_ATTRIBUTE21 PBY_ATTRIBUTE21
, PBY_ATTRIBUTE22 PBY_ATTRIBUTE22
, PBY_ATTRIBUTE23 PBY_ATTRIBUTE23
, PBY_ATTRIBUTE24 PBY_ATTRIBUTE24
, PBY_ATTRIBUTE25 PBY_ATTRIBUTE25
, PBY_ATTRIBUTE26 PBY_ATTRIBUTE26
, PBY_ATTRIBUTE27 PBY_ATTRIBUTE27
, PBY_ATTRIBUTE28 PBY_ATTRIBUTE28
, PBY_ATTRIBUTE29 PBY_ATTRIBUTE29
, PBY_ATTRIBUTE30 PBY_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
, CLG_AMT CLG_AMT
, FLR_AMT FLR_AMT
FROM "BEN"."BEN_PTD_BAL_TYP_F"