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_PROCESS_GROUP_ACTIONS

Object Details

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

PAY_PROCESS_GROUP_ACTIONS stores details of the individual
actions to be processed within the single process group submission.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PROCESS_GROUP_ACTIONS_PK

PROCESS_GROUP_ID
SEQUENCE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PROCESS_GROUP_ACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROCESS_GROUP_ID SEQUENCE
SYS_IL0000099839C00004$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_GROUP_ID	NUMBER	(15)	Yes	System Generated Primary Key
SEQUENCE	NUMBER		Yes	Sequence number for the processing. Also part of the Primary Key.
AOL_PROCESS_NAME	VARCHAR2	(30)	Yes	Name of the AOL executable to be used.
ARGUMENT_LIST	CLOB	(4000)		Select statement that defines the arguments to be used with this process.

Query Text

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


SELECT PROCESS_GROUP_ID
,      SEQUENCE
,      AOL_PROCESS_NAME
,      ARGUMENT_LIST
FROM HR.PAY_PROCESS_GROUP_ACTIONS;

Dependencies

[top of page]

HR.PAY_PROCESS_GROUP_ACTIONS does not reference any database object

HR.PAY_PROCESS_GROUP_ACTIONS is referenced by following:

HR: PAY_PROCESS_GROUP_ACTIONS#