eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PAY_ELE_TMPLT_CLASS_USAGES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

HR.PAY_ELE_TMPLT_CLASS_USAGES does not reference any database object

HR.PAY_ELE_TMPLT_CLASS_USAGES is referenced by following:

APPS: PAY_ELE_TMPLT_CLASS_USAGES
PUBLIC: PAY_ELE_TMPLT_CLASS_USAGES