[Home] [Help] [Dependency Information]
Object Name: | PAY_ELE_TMPLT_CLASS_USAGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_ELE_TMPLT_CLASS_USAGES |
Subobject Name: | |
Status: | VALID |
Intermediate Table of pay_element_templates and pay_element_classifications, which is used for Element Template Wizard.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_ELE_TMPLT_CLASS_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELE_TEMPLATE_CLASSIFICATION_ID |
PAY_ELE_TMPLT_CLASS_USAGES_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CLASSIFICATION_ID
TEMPLATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELE_TEMPLATE_CLASSIFICATION_ID | NUMBER | (9) | Yes | Element Template Classification ID |
CLASSIFICATION_ID | NUMBER | (9) | Yes | Element Classification ID |
TEMPLATE_ID | NUMBER | (9) | Yes | Element Template ID |
DISPLAY_PROCESS_MODE | VARCHAR2 | (30) | Display Process Mode | |
DISPLAY_ARREARAGE | VARCHAR2 | (30) | Display Arrearage |
Cut, paste (and edit) the following text to query this object:
SELECT ELE_TEMPLATE_CLASSIFICATION_ID
, CLASSIFICATION_ID
, TEMPLATE_ID
, DISPLAY_PROCESS_MODE
, DISPLAY_ARREARAGE
FROM HR.PAY_ELE_TMPLT_CLASS_USAGES;
HR.PAY_ELE_TMPLT_CLASS_USAGES does not reference any database object
HR.PAY_ELE_TMPLT_CLASS_USAGES is referenced by following:
|
|
|