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

VIEW: HR.PAY_UPGRADE_DEFINITIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
UPGRADE_DEFINITION_ID NUMBER (9) Yes
SHORT_NAME VARCHAR2 (30) Yes
NAME VARCHAR2 (80) Yes
LEGISLATION_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (250) Yes
UPGRADE_LEVEL VARCHAR2 (30) Yes
CRITICALITY VARCHAR2 (30) Yes
THREADING_LEVEL VARCHAR2 (30) Yes
FAILURE_POINT VARCHAR2 (30) Yes
LEGISLATIVELY_ENABLED VARCHAR2 (30) Yes
UPGRADE_METHOD VARCHAR2 (30) Yes
UPGRADE_PROCEDURE VARCHAR2 (250) Yes
QUALIFYING_PROCEDURE VARCHAR2 (250)
LAST_UPDATE_DATE DATE

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

FIRST_PATCHSET VARCHAR2 (30)
OWNER_APPLICATION_ID NUMBER (9)
VALIDATE_CODE VARCHAR2 (240)
ADDITIONAL_INFO VARCHAR2 (2000)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT UPGRADE_DEFINITION_ID
,      SHORT_NAME
,      NAME
,      LEGISLATION_CODE
,      DESCRIPTION
,      UPGRADE_LEVEL
,      CRITICALITY
,      THREADING_LEVEL
,      FAILURE_POINT
,      LEGISLATIVELY_ENABLED
,      UPGRADE_METHOD
,      UPGRADE_PROCEDURE
,      QUALIFYING_PROCEDURE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FIRST_PATCHSET
,      OWNER_APPLICATION_ID
,      VALIDATE_CODE
,      ADDITIONAL_INFO
,      ZD_EDITION_NAME
FROM HR.PAY_UPGRADE_DEFINITIONS#;

Dependencies

[top of page]

HR.PAY_UPGRADE_DEFINITIONS# references the following:

SchemaHR
TablePAY_UPGRADE_DEFINITIONS
HR.PAY_UPGRADE_DEFINITIONS# is referenced by following:

SchemaAPPS
SynonymPAY_UPGRADE_DEFINITIONS
TriggerPAY_UPGRADE_DEFINITIONS+
TriggerPAY_UPGRADE_DEFINITIONS_WHO