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.

VIEW: HR.PER_BF_BALANCE_AMOUNTS#

Source

View Text - Preformatted


select BALANCE_AMOUNT_ID BALANCE_AMOUNT_ID, BALANCE_TYPE_ID BALANCE_TYPE_ID, PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, YTD_AMOUNT YTD_AMOUNT, FYTD_AMOUNT FYTD_AMOUNT, PTD_AMOUNT PTD_AMOUNT, MTD_AMOUNT MTD_AMOUNT, QTD_AMOUNT QTD_AMOUNT, RUN_AMOUNT RUN_AMOUNT, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, BBA_ATTRIBUTE_CATEGORY BBA_ATTRIBUTE_CATEGORY, BBA_ATTRIBUTE1 BBA_ATTRIBUTE1, BBA_ATTRIBUTE2 BBA_ATTRIBUTE2, BBA_ATTRIBUTE3 BBA_ATTRIBUTE3, BBA_ATTRIBUTE4 BBA_ATTRIBUTE4, BBA_ATTRIBUTE5 BBA_ATTRIBUTE5, BBA_ATTRIBUTE6 BBA_ATTRIBUTE6, BBA_ATTRIBUTE7 BBA_ATTRIBUTE7, BBA_ATTRIBUTE8 BBA_ATTRIBUTE8, BBA_ATTRIBUTE9 BBA_ATTRIBUTE9, BBA_ATTRIBUTE10 BBA_ATTRIBUTE10, BBA_ATTRIBUTE11 BBA_ATTRIBUTE11, BBA_ATTRIBUTE12 BBA_ATTRIBUTE12, BBA_ATTRIBUTE13 BBA_ATTRIBUTE13, BBA_ATTRIBUTE14 BBA_ATTRIBUTE14, BBA_ATTRIBUTE15 BBA_ATTRIBUTE15, BBA_ATTRIBUTE16 BBA_ATTRIBUTE16, BBA_ATTRIBUTE17 BBA_ATTRIBUTE17, BBA_ATTRIBUTE18 BBA_ATTRIBUTE18, BBA_ATTRIBUTE19 BBA_ATTRIBUTE19, BBA_ATTRIBUTE20 BBA_ATTRIBUTE20, BBA_ATTRIBUTE21 BBA_ATTRIBUTE21, BBA_ATTRIBUTE22 BBA_ATTRIBUTE22, BBA_ATTRIBUTE23 BBA_ATTRIBUTE23, BBA_ATTRIBUTE24 BBA_ATTRIBUTE24, BBA_ATTRIBUTE25 BBA_ATTRIBUTE25, BBA_ATTRIBUTE26 BBA_ATTRIBUTE26, BBA_ATTRIBUTE27 BBA_ATTRIBUTE27, BBA_ATTRIBUTE28 BBA_ATTRIBUTE28, BBA_ATTRIBUTE29 BBA_ATTRIBUTE29, BBA_ATTRIBUTE30 BBA_ATTRIBUTE30 from "HR"."PER_BF_BALANCE_AMOUNTS"

View Text - HTML Formatted

SELECT BALANCE_AMOUNT_ID BALANCE_AMOUNT_ID
, BALANCE_TYPE_ID BALANCE_TYPE_ID
, PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, YTD_AMOUNT YTD_AMOUNT
, FYTD_AMOUNT FYTD_AMOUNT
, PTD_AMOUNT PTD_AMOUNT
, MTD_AMOUNT MTD_AMOUNT
, QTD_AMOUNT QTD_AMOUNT
, RUN_AMOUNT RUN_AMOUNT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, BBA_ATTRIBUTE_CATEGORY BBA_ATTRIBUTE_CATEGORY
, BBA_ATTRIBUTE1 BBA_ATTRIBUTE1
, BBA_ATTRIBUTE2 BBA_ATTRIBUTE2
, BBA_ATTRIBUTE3 BBA_ATTRIBUTE3
, BBA_ATTRIBUTE4 BBA_ATTRIBUTE4
, BBA_ATTRIBUTE5 BBA_ATTRIBUTE5
, BBA_ATTRIBUTE6 BBA_ATTRIBUTE6
, BBA_ATTRIBUTE7 BBA_ATTRIBUTE7
, BBA_ATTRIBUTE8 BBA_ATTRIBUTE8
, BBA_ATTRIBUTE9 BBA_ATTRIBUTE9
, BBA_ATTRIBUTE10 BBA_ATTRIBUTE10
, BBA_ATTRIBUTE11 BBA_ATTRIBUTE11
, BBA_ATTRIBUTE12 BBA_ATTRIBUTE12
, BBA_ATTRIBUTE13 BBA_ATTRIBUTE13
, BBA_ATTRIBUTE14 BBA_ATTRIBUTE14
, BBA_ATTRIBUTE15 BBA_ATTRIBUTE15
, BBA_ATTRIBUTE16 BBA_ATTRIBUTE16
, BBA_ATTRIBUTE17 BBA_ATTRIBUTE17
, BBA_ATTRIBUTE18 BBA_ATTRIBUTE18
, BBA_ATTRIBUTE19 BBA_ATTRIBUTE19
, BBA_ATTRIBUTE20 BBA_ATTRIBUTE20
, BBA_ATTRIBUTE21 BBA_ATTRIBUTE21
, BBA_ATTRIBUTE22 BBA_ATTRIBUTE22
, BBA_ATTRIBUTE23 BBA_ATTRIBUTE23
, BBA_ATTRIBUTE24 BBA_ATTRIBUTE24
, BBA_ATTRIBUTE25 BBA_ATTRIBUTE25
, BBA_ATTRIBUTE26 BBA_ATTRIBUTE26
, BBA_ATTRIBUTE27 BBA_ATTRIBUTE27
, BBA_ATTRIBUTE28 BBA_ATTRIBUTE28
, BBA_ATTRIBUTE29 BBA_ATTRIBUTE29
, BBA_ATTRIBUTE30 BBA_ATTRIBUTE30
FROM "HR"."PER_BF_BALANCE_AMOUNTS"