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_ENTRY_PROCESS_DETAILS

Object Details

Object Name:	PAY_ENTRY_PROCESS_DETAILS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_ENTRY_PROCESS_DETAILS
Subobject Name:
Status:	VALID

PAY_ENTRY_PROCESS_DETAILS is a Table that holds specific internal
processing details for certain types of Element Entries.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ENTRY_PROCESS_DETAILS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ASG_ACTION_ID
PAY_ENTRY_PROCESS_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_ENTRY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_ENTRY_ID	NUMBER	(15)	Yes	Foreign key to PAY_ELEMENT_ENTRIES_F
SOURCE_ELEMENT_TYPE_ID	NUMBER	(9)		Foreign key to PAY_ELEMENT_TYPES_F
SOURCE_ENTRY_ID	NUMBER	(15)		Foreign key to PAY_ELEMENT_ENTRIES_F
SOURCE_ASG_ACTION_ID	NUMBER	(15)		Foreign key to PAY_ASSIGNMENT_ACTIONS
RETRO_COMPONENT_ID	NUMBER	(9)		Foreign key to PAY_RETRO_COMPONENTS
RUN_RESULT_ID	NUMBER	(15)		Foreign key to PAY_RUN_RESULTS
TAX_UNIT_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS
PROCESS_PATH	VARCHAR2	(2000)		Process Path is used to identify the Run Type that the entry should be processed in.
ADJUSTMENT_TYPE	VARCHAR2	(30)		Adjustment Type
ENTRY_PROCESS_PATH	VARCHAR2	(1000)		Entry Process Path
TIME_DEFINITION_ID	NUMBER	(9)		Foreign Key to PAY_TIM_DEFINITIONS.

Query Text

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


SELECT ELEMENT_ENTRY_ID
,      SOURCE_ELEMENT_TYPE_ID
,      SOURCE_ENTRY_ID
,      SOURCE_ASG_ACTION_ID
,      RETRO_COMPONENT_ID
,      RUN_RESULT_ID
,      TAX_UNIT_ID
,      PROCESS_PATH
,      ADJUSTMENT_TYPE
,      ENTRY_PROCESS_PATH
,      TIME_DEFINITION_ID
FROM HR.PAY_ENTRY_PROCESS_DETAILS;

Dependencies

[top of page]

HR.PAY_ENTRY_PROCESS_DETAILS does not reference any database object

HR.PAY_ENTRY_PROCESS_DETAILS is referenced by following:

HR: PAY_ENTRY_PROCESS_DETAILS#