[Home] [Help] [Dependency Information]
Object Name: | PAY_FUNCTIONAL_TRIGGERS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_FUNCTIONAL_TRIGGERS |
Subobject Name: | |
Status: | VALID |
PAY_FUNCTIONAL_TRIGGERS is the link entity between pay_trigger_events
and pay_functional_areas. Defines which functional area(s) a trigger event
definition belongs to. It is perfectly possible for a triggering event to be in
more than one functional area, although it''s possibly not a very good idea.
The initial action of placing a trigger in a new functional area (by placing a
row in this table) will actually disable that trigger. This (see logic for
''trigger_is_not_enabled'' function) is because the trigger now belongs to
an area which is not enabled for any context (one of legislation, business
group or payroll), by placing a row in pay_functional_usages which does
not contain any context the triggers in this functional area will be enabled
for all contexts. If a new trigger is placed into a functional area for which
context enablements have already been defined then it will inherit the
properties of that existing area. This information will probably be seeded
and users will not be given the access required to maintain it.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_FUNCTIONAL_TRIGGERS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRIGGER_ID |
PAY_FUNCTIONAL_TRIGGERS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AREA_ID
EVENT_ID |
PAY_FUNCTIONAL_TRIGGERS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EVENT_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_FUNCTIONAL_TRIGGERS | PAY_FUNCTIONAL_AREAS | PAY_FUNCTIONAL_TRIGGERS AREA_ID | PAY_FUNCTIONAL_TRIGGERS | PAY_TRIGGER_EVENTS | PAY_FUNCTIONAL_TRIGGERS EVENT_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRIGGER_ID | NUMBER | (15) | Yes | System-generated primary key column. |
AREA_ID | NUMBER | (15) | Yes | Foreign key to PAY_FUNCTIONAL_AREAS. |
EVENT_ID | NUMBER | (15) | Yes | Foreign key to PAY_TRIGGER_EVENTS. |
LAST_UPDATE_DATE | DATE | Standard Who Column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard Who Column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard Who Column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT TRIGGER_ID
, AREA_ID
, EVENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PAY_FUNCTIONAL_TRIGGERS;
HR.PAY_FUNCTIONAL_TRIGGERS does not reference any database object
HR.PAY_FUNCTIONAL_TRIGGERS is referenced by following:
|
|
|