[Home] [Help] [Dependency Information]
Object Name: | PAY_RETRO_DEFINITIONS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_RETRO_DEFINITIONS |
Subobject Name: | |
Status: | VALID |
Contains details like definition name and its short name for a particular legislation
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RETRO_DEFINITION_ID | NUMBER | (9) | Yes | Unique key to PAY_RETRO_DEFINITIONS table |
SHORT_NAME | VARCHAR2 | (30) | Yes | Short name for the defintion |
DEFINITION_NAME | VARCHAR2 | (60) | Yes | Name for the defintion |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code |
Cut, paste (and edit) the following text to query this object:
SELECT RETRO_DEFINITION_ID
, SHORT_NAME
, DEFINITION_NAME
, LEGISLATION_CODE
FROM HR.PAY_RETRO_DEFINITIONS;
HR.PAY_RETRO_DEFINITIONS does not reference any database object
HR.PAY_RETRO_DEFINITIONS is referenced by following:
|
|
|