[Home] [Help] [Dependency Information]

TABLE: HR.PAY_TRIGGER_SUPPORT

Object Details

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

PAY_TRIGGER_SUPPORT is used to store any support code which the
trigger may require. This should be stored as PL/SQL code which will
create a database package. It is simply a mechanism for easily
associating any support procedures with the triggers which call them.
The user must not supply the CREATE OR REPLACE statements or the
final END statements. These will be automatically added by the generator.
The packages will be named as _DYG to indicate that
they are DYnamically generated packaGes. The name of the table that
the associated trigger will be created against (truncated to 26 characters)
will be substituted for TABLE_NAME. The user does not need to use this
facility as the generator can create code which calls any other code
objects in the database but it will prefer this package when listing
available code in LOVs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_TRIGGER_SUPPORT_PK

1. SUPPORT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_TRIGGER_SUPPORT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUPPORT_ID
SYS_IL0000099852C00003$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000099852C00004$$	LOB	UNIQUE	APPS_TS_TX_DATA
PAY_TRIGGER_SUPPORT_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_TRIGGER_SUPPORT		PAY_TRIGGER_EVENTS	PAY_TRIGGER_SUPPORT EVENT_ID

Columns

Query Text

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

SELECT SUPPORT_ID
,      EVENT_ID
,      HEADER_CODE
,      BODY_CODE
FROM HR.PAY_TRIGGER_SUPPORT;

Dependencies

[top of page]

HR.PAY_TRIGGER_SUPPORT does not reference any database object

HR.PAY_TRIGGER_SUPPORT is referenced by following:

APPS

PAY_TRIGGER_SUPPORT

PUBLIC

PAY_TRIGGER_SUPPORT