DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.PAY_ELEMENT_TEMPLATES#

Object Details
Object Name: PAY_ELEMENT_TEMPLATES#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (9) Yes
TEMPLATE_TYPE VARCHAR2 (30) Yes
TEMPLATE_NAME VARCHAR2 (80) Yes
BASE_PROCESSING_PRIORITY NUMBER (9) Yes
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
VERSION_NUMBER NUMBER
Yes
BASE_NAME VARCHAR2 (50)
MAX_BASE_NAME_LENGTH NUMBER (9) Yes
PREFERENCE_INFO_CATEGORY VARCHAR2 (30)
PREFERENCE_INFORMATION1 VARCHAR2 (150)
PREFERENCE_INFORMATION2 VARCHAR2 (150)
PREFERENCE_INFORMATION3 VARCHAR2 (150)
PREFERENCE_INFORMATION4 VARCHAR2 (150)
PREFERENCE_INFORMATION5 VARCHAR2 (150)
PREFERENCE_INFORMATION6 VARCHAR2 (150)
PREFERENCE_INFORMATION7 VARCHAR2 (150)
PREFERENCE_INFORMATION8 VARCHAR2 (150)
PREFERENCE_INFORMATION9 VARCHAR2 (150)
PREFERENCE_INFORMATION10 VARCHAR2 (150)
PREFERENCE_INFORMATION11 VARCHAR2 (150)
PREFERENCE_INFORMATION12 VARCHAR2 (150)
PREFERENCE_INFORMATION13 VARCHAR2 (150)
PREFERENCE_INFORMATION14 VARCHAR2 (150)
PREFERENCE_INFORMATION15 VARCHAR2 (150)
PREFERENCE_INFORMATION16 VARCHAR2 (150)
PREFERENCE_INFORMATION17 VARCHAR2 (150)
PREFERENCE_INFORMATION18 VARCHAR2 (150)
PREFERENCE_INFORMATION19 VARCHAR2 (240)
PREFERENCE_INFORMATION20 VARCHAR2 (150)
PREFERENCE_INFORMATION21 VARCHAR2 (150)
PREFERENCE_INFORMATION22 VARCHAR2 (150)
PREFERENCE_INFORMATION23 VARCHAR2 (150)
PREFERENCE_INFORMATION24 VARCHAR2 (150)
PREFERENCE_INFORMATION25 VARCHAR2 (150)
PREFERENCE_INFORMATION26 VARCHAR2 (150)
PREFERENCE_INFORMATION27 VARCHAR2 (150)
PREFERENCE_INFORMATION28 VARCHAR2 (150)
PREFERENCE_INFORMATION29 VARCHAR2 (150)
PREFERENCE_INFORMATION30 VARCHAR2 (150)
CONFIGURATION_INFO_CATEGORY VARCHAR2 (30)
CONFIGURATION_INFORMATION1 VARCHAR2 (150)
CONFIGURATION_INFORMATION2 VARCHAR2 (150)
CONFIGURATION_INFORMATION3 VARCHAR2 (150)
CONFIGURATION_INFORMATION4 VARCHAR2 (150)
CONFIGURATION_INFORMATION5 VARCHAR2 (150)
CONFIGURATION_INFORMATION6 VARCHAR2 (150)
CONFIGURATION_INFORMATION7 VARCHAR2 (150)
CONFIGURATION_INFORMATION8 VARCHAR2 (150)
CONFIGURATION_INFORMATION9 VARCHAR2 (150)
CONFIGURATION_INFORMATION10 VARCHAR2 (150)
CONFIGURATION_INFORMATION11 VARCHAR2 (150)
CONFIGURATION_INFORMATION12 VARCHAR2 (150)
CONFIGURATION_INFORMATION13 VARCHAR2 (150)
CONFIGURATION_INFORMATION14 VARCHAR2 (150)
CONFIGURATION_INFORMATION15 VARCHAR2 (150)
CONFIGURATION_INFORMATION16 VARCHAR2 (150)
CONFIGURATION_INFORMATION17 VARCHAR2 (150)
CONFIGURATION_INFORMATION18 VARCHAR2 (150)
CONFIGURATION_INFORMATION19 VARCHAR2 (150)
CONFIGURATION_INFORMATION20 VARCHAR2 (150)
CONFIGURATION_INFORMATION21 VARCHAR2 (150)
CONFIGURATION_INFORMATION22 VARCHAR2 (150)
CONFIGURATION_INFORMATION23 VARCHAR2 (150)
CONFIGURATION_INFORMATION24 VARCHAR2 (150)
CONFIGURATION_INFORMATION25 VARCHAR2 (150)
CONFIGURATION_INFORMATION26 VARCHAR2 (150)
CONFIGURATION_INFORMATION27 VARCHAR2 (150)
CONFIGURATION_INFORMATION28 VARCHAR2 (150)
CONFIGURATION_INFORMATION29 VARCHAR2 (150)
CONFIGURATION_INFORMATION30 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

HR.PAY_ELEMENT_TEMPLATES# references the following:

SchemaHR
TablePAY_ELEMENT_TEMPLATES
HR.PAY_ELEMENT_TEMPLATES# is referenced by following:

SchemaAPPS
SynonymPAY_ELEMENT_TEMPLATES
TriggerPAY_ELEMENT_TEMPLATES+
TriggerPAY_ELEMENT_TEMPLATES_WHO