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: HR.PER_BF_PAYMENT_DETAILS#

Source

View Text - Preformatted


select PAYMENT_DETAIL_ID PAYMENT_DETAIL_ID, PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CHECK_NUMBER CHECK_NUMBER, PAYMENT_DATE PAYMENT_DATE, AMOUNT AMOUNT, CHECK_TYPE CHECK_TYPE, 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, BPD_ATTRIBUTE_CATEGORY BPD_ATTRIBUTE_CATEGORY, BPD_ATTRIBUTE1 BPD_ATTRIBUTE1, BPD_ATTRIBUTE2 BPD_ATTRIBUTE2, BPD_ATTRIBUTE3 BPD_ATTRIBUTE3, BPD_ATTRIBUTE4 BPD_ATTRIBUTE4, BPD_ATTRIBUTE5 BPD_ATTRIBUTE5, BPD_ATTRIBUTE6 BPD_ATTRIBUTE6, BPD_ATTRIBUTE7 BPD_ATTRIBUTE7, BPD_ATTRIBUTE8 BPD_ATTRIBUTE8, BPD_ATTRIBUTE9 BPD_ATTRIBUTE9, BPD_ATTRIBUTE10 BPD_ATTRIBUTE10, BPD_ATTRIBUTE11 BPD_ATTRIBUTE11, BPD_ATTRIBUTE12 BPD_ATTRIBUTE12, BPD_ATTRIBUTE13 BPD_ATTRIBUTE13, BPD_ATTRIBUTE14 BPD_ATTRIBUTE14, BPD_ATTRIBUTE15 BPD_ATTRIBUTE15, BPD_ATTRIBUTE16 BPD_ATTRIBUTE16, BPD_ATTRIBUTE17 BPD_ATTRIBUTE17, BPD_ATTRIBUTE18 BPD_ATTRIBUTE18, BPD_ATTRIBUTE19 BPD_ATTRIBUTE19, BPD_ATTRIBUTE20 BPD_ATTRIBUTE20, BPD_ATTRIBUTE21 BPD_ATTRIBUTE21, BPD_ATTRIBUTE22 BPD_ATTRIBUTE22, BPD_ATTRIBUTE23 BPD_ATTRIBUTE23, BPD_ATTRIBUTE24 BPD_ATTRIBUTE24, BPD_ATTRIBUTE25 BPD_ATTRIBUTE25, BPD_ATTRIBUTE26 BPD_ATTRIBUTE26, BPD_ATTRIBUTE27 BPD_ATTRIBUTE27, BPD_ATTRIBUTE28 BPD_ATTRIBUTE28, BPD_ATTRIBUTE29 BPD_ATTRIBUTE29, BPD_ATTRIBUTE30 BPD_ATTRIBUTE30 from "HR"."PER_BF_PAYMENT_DETAILS"

View Text - HTML Formatted

SELECT PAYMENT_DETAIL_ID PAYMENT_DETAIL_ID
, PROCESSED_ASSIGNMENT_ID PROCESSED_ASSIGNMENT_ID
, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CHECK_NUMBER CHECK_NUMBER
, PAYMENT_DATE PAYMENT_DATE
, AMOUNT AMOUNT
, CHECK_TYPE CHECK_TYPE
, 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
, BPD_ATTRIBUTE_CATEGORY BPD_ATTRIBUTE_CATEGORY
, BPD_ATTRIBUTE1 BPD_ATTRIBUTE1
, BPD_ATTRIBUTE2 BPD_ATTRIBUTE2
, BPD_ATTRIBUTE3 BPD_ATTRIBUTE3
, BPD_ATTRIBUTE4 BPD_ATTRIBUTE4
, BPD_ATTRIBUTE5 BPD_ATTRIBUTE5
, BPD_ATTRIBUTE6 BPD_ATTRIBUTE6
, BPD_ATTRIBUTE7 BPD_ATTRIBUTE7
, BPD_ATTRIBUTE8 BPD_ATTRIBUTE8
, BPD_ATTRIBUTE9 BPD_ATTRIBUTE9
, BPD_ATTRIBUTE10 BPD_ATTRIBUTE10
, BPD_ATTRIBUTE11 BPD_ATTRIBUTE11
, BPD_ATTRIBUTE12 BPD_ATTRIBUTE12
, BPD_ATTRIBUTE13 BPD_ATTRIBUTE13
, BPD_ATTRIBUTE14 BPD_ATTRIBUTE14
, BPD_ATTRIBUTE15 BPD_ATTRIBUTE15
, BPD_ATTRIBUTE16 BPD_ATTRIBUTE16
, BPD_ATTRIBUTE17 BPD_ATTRIBUTE17
, BPD_ATTRIBUTE18 BPD_ATTRIBUTE18
, BPD_ATTRIBUTE19 BPD_ATTRIBUTE19
, BPD_ATTRIBUTE20 BPD_ATTRIBUTE20
, BPD_ATTRIBUTE21 BPD_ATTRIBUTE21
, BPD_ATTRIBUTE22 BPD_ATTRIBUTE22
, BPD_ATTRIBUTE23 BPD_ATTRIBUTE23
, BPD_ATTRIBUTE24 BPD_ATTRIBUTE24
, BPD_ATTRIBUTE25 BPD_ATTRIBUTE25
, BPD_ATTRIBUTE26 BPD_ATTRIBUTE26
, BPD_ATTRIBUTE27 BPD_ATTRIBUTE27
, BPD_ATTRIBUTE28 BPD_ATTRIBUTE28
, BPD_ATTRIBUTE29 BPD_ATTRIBUTE29
, BPD_ATTRIBUTE30 BPD_ATTRIBUTE30
FROM "HR"."PER_BF_PAYMENT_DETAILS"