VIEW: HR.PAY_ELEMENT_TEMPLATES#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, TEMPLATE_TYPE TEMPLATE_TYPE, TEMPLATE_NAME TEMPLATE_NAME, BASE_PROCESSING_PRIORITY BASE_PROCESSING_PRIORITY, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, VERSION_NUMBER VERSION_NUMBER, BASE_NAME BASE_NAME, MAX_BASE_NAME_LENGTH MAX_BASE_NAME_LENGTH, PREFERENCE_INFO_CATEGORY PREFERENCE_INFO_CATEGORY, PREFERENCE_INFORMATION1 PREFERENCE_INFORMATION1, PREFERENCE_INFORMATION2 PREFERENCE_INFORMATION2, PREFERENCE_INFORMATION3 PREFERENCE_INFORMATION3, PREFERENCE_INFORMATION4 PREFERENCE_INFORMATION4, PREFERENCE_INFORMATION5 PREFERENCE_INFORMATION5, PREFERENCE_INFORMATION6 PREFERENCE_INFORMATION6, PREFERENCE_INFORMATION7 PREFERENCE_INFORMATION7, PREFERENCE_INFORMATION8 PREFERENCE_INFORMATION8, PREFERENCE_INFORMATION9 PREFERENCE_INFORMATION9, PREFERENCE_INFORMATION10 PREFERENCE_INFORMATION10, PREFERENCE_INFORMATION11 PREFERENCE_INFORMATION11, PREFERENCE_INFORMATION12 PREFERENCE_INFORMATION12, PREFERENCE_INFORMATION13 PREFERENCE_INFORMATION13, PREFERENCE_INFORMATION14 PREFERENCE_INFORMATION14, PREFERENCE_INFORMATION15 PREFERENCE_INFORMATION15, PREFERENCE_INFORMATION16 PREFERENCE_INFORMATION16, PREFERENCE_INFORMATION17 PREFERENCE_INFORMATION17, PREFERENCE_INFORMATION18 PREFERENCE_INFORMATION18, PREFERENCE_INFORMATION19 PREFERENCE_INFORMATION19, PREFERENCE_INFORMATION20 PREFERENCE_INFORMATION20, PREFERENCE_INFORMATION21 PREFERENCE_INFORMATION21, PREFERENCE_INFORMATION22 PREFERENCE_INFORMATION22, PREFERENCE_INFORMATION23 PREFERENCE_INFORMATION23, PREFERENCE_INFORMATION24 PREFERENCE_INFORMATION24, PREFERENCE_INFORMATION25 PREFERENCE_INFORMATION25, PREFERENCE_INFORMATION26 PREFERENCE_INFORMATION26, PREFERENCE_INFORMATION27 PREFERENCE_INFORMATION27, PREFERENCE_INFORMATION28 PREFERENCE_INFORMATION28, PREFERENCE_INFORMATION29 PREFERENCE_INFORMATION29, PREFERENCE_INFORMATION30 PREFERENCE_INFORMATION30, CONFIGURATION_INFO_CATEGORY CONFIGURATION_INFO_CATEGORY, CONFIGURATION_INFORMATION1 CONFIGURATION_INFORMATION1, CONFIGURATION_INFORMATION2 CONFIGURATION_INFORMATION2, CONFIGURATION_INFORMATION3 CONFIGURATION_INFORMATION3, CONFIGURATION_INFORMATION4 CONFIGURATION_INFORMATION4, CONFIGURATION_INFORMATION5 CONFIGURATION_INFORMATION5, CONFIGURATION_INFORMATION6 CONFIGURATION_INFORMATION6, CONFIGURATION_INFORMATION7 CONFIGURATION_INFORMATION7, CONFIGURATION_INFORMATION8 CONFIGURATION_INFORMATION8, CONFIGURATION_INFORMATION9 CONFIGURATION_INFORMATION9, CONFIGURATION_INFORMATION10 CONFIGURATION_INFORMATION10, CONFIGURATION_INFORMATION11 CONFIGURATION_INFORMATION11, CONFIGURATION_INFORMATION12 CONFIGURATION_INFORMATION12, CONFIGURATION_INFORMATION13 CONFIGURATION_INFORMATION13, CONFIGURATION_INFORMATION14 CONFIGURATION_INFORMATION14, CONFIGURATION_INFORMATION15 CONFIGURATION_INFORMATION15, CONFIGURATION_INFORMATION16 CONFIGURATION_INFORMATION16, CONFIGURATION_INFORMATION17 CONFIGURATION_INFORMATION17, CONFIGURATION_INFORMATION18 CONFIGURATION_INFORMATION18, CONFIGURATION_INFORMATION19 CONFIGURATION_INFORMATION19, CONFIGURATION_INFORMATION20 CONFIGURATION_INFORMATION20, CONFIGURATION_INFORMATION21 CONFIGURATION_INFORMATION21, CONFIGURATION_INFORMATION22 CONFIGURATION_INFORMATION22, CONFIGURATION_INFORMATION23 CONFIGURATION_INFORMATION23, CONFIGURATION_INFORMATION24 CONFIGURATION_INFORMATION24, CONFIGURATION_INFORMATION25 CONFIGURATION_INFORMATION25, CONFIGURATION_INFORMATION26 CONFIGURATION_INFORMATION26, CONFIGURATION_INFORMATION27 CONFIGURATION_INFORMATION27, CONFIGURATION_INFORMATION28 CONFIGURATION_INFORMATION28, CONFIGURATION_INFORMATION29 CONFIGURATION_INFORMATION29, CONFIGURATION_INFORMATION30 CONFIGURATION_INFORMATION30, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_ELEMENT_TEMPLATES"

View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_TYPE TEMPLATE_TYPE
, TEMPLATE_NAME TEMPLATE_NAME
, BASE_PROCESSING_PRIORITY BASE_PROCESSING_PRIORITY
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, VERSION_NUMBER VERSION_NUMBER
, BASE_NAME BASE_NAME
, MAX_BASE_NAME_LENGTH MAX_BASE_NAME_LENGTH
, PREFERENCE_INFO_CATEGORY PREFERENCE_INFO_CATEGORY
, PREFERENCE_INFORMATION1 PREFERENCE_INFORMATION1
, PREFERENCE_INFORMATION2 PREFERENCE_INFORMATION2
, PREFERENCE_INFORMATION3 PREFERENCE_INFORMATION3
, PREFERENCE_INFORMATION4 PREFERENCE_INFORMATION4
, PREFERENCE_INFORMATION5 PREFERENCE_INFORMATION5
, PREFERENCE_INFORMATION6 PREFERENCE_INFORMATION6
, PREFERENCE_INFORMATION7 PREFERENCE_INFORMATION7
, PREFERENCE_INFORMATION8 PREFERENCE_INFORMATION8
, PREFERENCE_INFORMATION9 PREFERENCE_INFORMATION9
, PREFERENCE_INFORMATION10 PREFERENCE_INFORMATION10
, PREFERENCE_INFORMATION11 PREFERENCE_INFORMATION11
, PREFERENCE_INFORMATION12 PREFERENCE_INFORMATION12
, PREFERENCE_INFORMATION13 PREFERENCE_INFORMATION13
, PREFERENCE_INFORMATION14 PREFERENCE_INFORMATION14
, PREFERENCE_INFORMATION15 PREFERENCE_INFORMATION15
, PREFERENCE_INFORMATION16 PREFERENCE_INFORMATION16
, PREFERENCE_INFORMATION17 PREFERENCE_INFORMATION17
, PREFERENCE_INFORMATION18 PREFERENCE_INFORMATION18
, PREFERENCE_INFORMATION19 PREFERENCE_INFORMATION19
, PREFERENCE_INFORMATION20 PREFERENCE_INFORMATION20
, PREFERENCE_INFORMATION21 PREFERENCE_INFORMATION21
, PREFERENCE_INFORMATION22 PREFERENCE_INFORMATION22
, PREFERENCE_INFORMATION23 PREFERENCE_INFORMATION23
, PREFERENCE_INFORMATION24 PREFERENCE_INFORMATION24
, PREFERENCE_INFORMATION25 PREFERENCE_INFORMATION25
, PREFERENCE_INFORMATION26 PREFERENCE_INFORMATION26
, PREFERENCE_INFORMATION27 PREFERENCE_INFORMATION27
, PREFERENCE_INFORMATION28 PREFERENCE_INFORMATION28
, PREFERENCE_INFORMATION29 PREFERENCE_INFORMATION29
, PREFERENCE_INFORMATION30 PREFERENCE_INFORMATION30
, CONFIGURATION_INFO_CATEGORY CONFIGURATION_INFO_CATEGORY
, CONFIGURATION_INFORMATION1 CONFIGURATION_INFORMATION1
, CONFIGURATION_INFORMATION2 CONFIGURATION_INFORMATION2
, CONFIGURATION_INFORMATION3 CONFIGURATION_INFORMATION3
, CONFIGURATION_INFORMATION4 CONFIGURATION_INFORMATION4
, CONFIGURATION_INFORMATION5 CONFIGURATION_INFORMATION5
, CONFIGURATION_INFORMATION6 CONFIGURATION_INFORMATION6
, CONFIGURATION_INFORMATION7 CONFIGURATION_INFORMATION7
, CONFIGURATION_INFORMATION8 CONFIGURATION_INFORMATION8
, CONFIGURATION_INFORMATION9 CONFIGURATION_INFORMATION9
, CONFIGURATION_INFORMATION10 CONFIGURATION_INFORMATION10
, CONFIGURATION_INFORMATION11 CONFIGURATION_INFORMATION11
, CONFIGURATION_INFORMATION12 CONFIGURATION_INFORMATION12
, CONFIGURATION_INFORMATION13 CONFIGURATION_INFORMATION13
, CONFIGURATION_INFORMATION14 CONFIGURATION_INFORMATION14
, CONFIGURATION_INFORMATION15 CONFIGURATION_INFORMATION15
, CONFIGURATION_INFORMATION16 CONFIGURATION_INFORMATION16
, CONFIGURATION_INFORMATION17 CONFIGURATION_INFORMATION17
, CONFIGURATION_INFORMATION18 CONFIGURATION_INFORMATION18
, CONFIGURATION_INFORMATION19 CONFIGURATION_INFORMATION19
, CONFIGURATION_INFORMATION20 CONFIGURATION_INFORMATION20
, CONFIGURATION_INFORMATION21 CONFIGURATION_INFORMATION21
, CONFIGURATION_INFORMATION22 CONFIGURATION_INFORMATION22
, CONFIGURATION_INFORMATION23 CONFIGURATION_INFORMATION23
, CONFIGURATION_INFORMATION24 CONFIGURATION_INFORMATION24
, CONFIGURATION_INFORMATION25 CONFIGURATION_INFORMATION25
, CONFIGURATION_INFORMATION26 CONFIGURATION_INFORMATION26
, CONFIGURATION_INFORMATION27 CONFIGURATION_INFORMATION27
, CONFIGURATION_INFORMATION28 CONFIGURATION_INFORMATION28
, CONFIGURATION_INFORMATION29 CONFIGURATION_INFORMATION29
, CONFIGURATION_INFORMATION30 CONFIGURATION_INFORMATION30
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_ELEMENT_TEMPLATES"