VIEW: HR.PAY_PERSONAL_PAYMENT_METHODS_#

Source

View Text - Preformatted

select PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, AMOUNT AMOUNT, COMMENT_ID COMMENT_ID, PERCENTAGE PERCENTAGE, PRIORITY PRIORITY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, 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, PAYEE_ID PAYEE_ID, PAYEE_TYPE PAYEE_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PERSON_ID PERSON_ID, RUN_TYPE_ID RUN_TYPE_ID, PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY, PPM_INFORMATION1 PPM_INFORMATION1, PPM_INFORMATION2 PPM_INFORMATION2, PPM_INFORMATION3 PPM_INFORMATION3, PPM_INFORMATION4 PPM_INFORMATION4, PPM_INFORMATION5 PPM_INFORMATION5, PPM_INFORMATION6 PPM_INFORMATION6, PPM_INFORMATION7 PPM_INFORMATION7, PPM_INFORMATION8 PPM_INFORMATION8, PPM_INFORMATION9 PPM_INFORMATION9, PPM_INFORMATION10 PPM_INFORMATION10, PPM_INFORMATION11 PPM_INFORMATION11, PPM_INFORMATION12 PPM_INFORMATION12, PPM_INFORMATION13 PPM_INFORMATION13, PPM_INFORMATION14 PPM_INFORMATION14, PPM_INFORMATION15 PPM_INFORMATION15, PPM_INFORMATION16 PPM_INFORMATION16, PPM_INFORMATION17 PPM_INFORMATION17, PPM_INFORMATION18 PPM_INFORMATION18, PPM_INFORMATION19 PPM_INFORMATION19, PPM_INFORMATION20 PPM_INFORMATION20, PPM_INFORMATION21 PPM_INFORMATION21, PPM_INFORMATION22 PPM_INFORMATION22, PPM_INFORMATION23 PPM_INFORMATION23, PPM_INFORMATION24 PPM_INFORMATION24, PPM_INFORMATION25 PPM_INFORMATION25, PPM_INFORMATION26 PPM_INFORMATION26, PPM_INFORMATION27 PPM_INFORMATION27, PPM_INFORMATION28 PPM_INFORMATION28, PPM_INFORMATION29 PPM_INFORMATION29, PPM_INFORMATION30 PPM_INFORMATION30 from "HR"."PAY_PERSONAL_PAYMENT_METHODS_F"

View Text - HTML Formatted

SELECT PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, AMOUNT AMOUNT
, COMMENT_ID COMMENT_ID
, PERCENTAGE PERCENTAGE
, PRIORITY PRIORITY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, 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
, PAYEE_ID PAYEE_ID
, PAYEE_TYPE PAYEE_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PERSON_ID PERSON_ID
, RUN_TYPE_ID RUN_TYPE_ID
, PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY
, PPM_INFORMATION1 PPM_INFORMATION1
, PPM_INFORMATION2 PPM_INFORMATION2
, PPM_INFORMATION3 PPM_INFORMATION3
, PPM_INFORMATION4 PPM_INFORMATION4
, PPM_INFORMATION5 PPM_INFORMATION5
, PPM_INFORMATION6 PPM_INFORMATION6
, PPM_INFORMATION7 PPM_INFORMATION7
, PPM_INFORMATION8 PPM_INFORMATION8
, PPM_INFORMATION9 PPM_INFORMATION9
, PPM_INFORMATION10 PPM_INFORMATION10
, PPM_INFORMATION11 PPM_INFORMATION11
, PPM_INFORMATION12 PPM_INFORMATION12
, PPM_INFORMATION13 PPM_INFORMATION13
, PPM_INFORMATION14 PPM_INFORMATION14
, PPM_INFORMATION15 PPM_INFORMATION15
, PPM_INFORMATION16 PPM_INFORMATION16
, PPM_INFORMATION17 PPM_INFORMATION17
, PPM_INFORMATION18 PPM_INFORMATION18
, PPM_INFORMATION19 PPM_INFORMATION19
, PPM_INFORMATION20 PPM_INFORMATION20
, PPM_INFORMATION21 PPM_INFORMATION21
, PPM_INFORMATION22 PPM_INFORMATION22
, PPM_INFORMATION23 PPM_INFORMATION23
, PPM_INFORMATION24 PPM_INFORMATION24
, PPM_INFORMATION25 PPM_INFORMATION25
, PPM_INFORMATION26 PPM_INFORMATION26
, PPM_INFORMATION27 PPM_INFORMATION27
, PPM_INFORMATION28 PPM_INFORMATION28
, PPM_INFORMATION29 PPM_INFORMATION29
, PPM_INFORMATION30 PPM_INFORMATION30
FROM "HR"."PAY_PERSONAL_PAYMENT_METHODS_F"