[Home] [Help] [Dependency Information]

TABLE: HR.PAY_ACTION_INTERLOCKS

Object Details

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

PAY_ACTION_INTERLOCKS holds the locking rules that allow one
assignment action to lock another. For example, the interlock
mechanism will prevent you from rolling back the payroll run
assignment action for a payroll if you have subsequently run the
prepayments process for the run. You must rollback the prepayment
action before you can rollback the payroll run. Interlock rows
support some, but not all, of the assignment level interlock rule
functionality. Interlock rows usually exist for unsequenced actions,
such as prepayments or costing and they lock either a sequenced or
another unsequenced action. There are separate but related rules for
sequenced actions such as the payroll run, QuickPay, reversal and
balance adjustment actions. Sequenced actions must also check for the
existence of other sequenced actions in the future. For example, you
cannot rollback a payroll run if there is another payroll run in the
future. This would invalidate the future payroll run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ACTION_INTERLOCKS_PK

1. LOCKING_ACTION_ID
2. LOCKED_ACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ACTION_INTERLOCKS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCKING_ACTION_ID LOCKED_ACTION_ID
PAY_ACTION_INTERLOCKS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCKED_ACTION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_ACTION_INTERLOCKS		PAY_ASSIGNMENT_ACTIONS	PAY_ACTION_INTERLOCKS LOCKED_ACTION_ID
PAY_ACTION_INTERLOCKS		PAY_ASSIGNMENT_ACTIONS	PAY_ACTION_INTERLOCKS LOCKING_ACTION_ID

Columns

Query Text

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

SELECT LOCKING_ACTION_ID
,      LOCKED_ACTION_ID
FROM HR.PAY_ACTION_INTERLOCKS;

Dependencies

[top of page]

HR.PAY_ACTION_INTERLOCKS does not reference any database object

HR.PAY_ACTION_INTERLOCKS is referenced by following:

APPS

PAY_ACTION_INTERLOCKS

PUBLIC

PAY_ACTION_INTERLOCKS