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

TABLE: HR.PAY_UPGRADE_LEGISLATIONS

Object Details
Object Name: PAY_UPGRADE_LEGISLATIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_UPGRADE_LEGISLATIONS
Subobject Name:
Status: VALID


This table is used for Global Upgrades that are Legislatively Enabled. These upgrades are only availible to legislations that have explicitly enabled them. This table is used to enable those upgrades.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UPGRADE_DEFINITION_ID NUMBER (9) Yes Foreign key to PAY_UPGRADE_DEFINITIONS
LEGISLATION_CODE VARCHAR2 (30) Yes Legislation Code
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT UPGRADE_DEFINITION_ID
,      LEGISLATION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_UPGRADE_LEGISLATIONS;

Dependencies

[top of page]

HR.PAY_UPGRADE_LEGISLATIONS does not reference any database object

HR.PAY_UPGRADE_LEGISLATIONS is referenced by following:

SchemaAPPS
SynonymPAY_UPGRADE_LEGISLATIONS
TriggerPAY_UPGRADE_LEGISLATIONS_WHO
SchemaPUBLIC
SynonymPAY_UPGRADE_LEGISLATIONS