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_FUNCTIONAL_USAGES

Object Details

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

PAY_FUNCTIONAL_USAGES defines which functional areas are switched on, and under what circumstances. i.e. The values for legislation code, business group or payroll which cause the trigger logic of triggers in this functional area to be executed. The trigger is executed based on the following logic (obviously only triggers that are enabled at the database level will fire);
IF the trigger is not in any functional area THEN
execute the trigger
ELSIF the trigger belongs to any functional area which is enabled for all contexts (a usage with no context information exists) THEN
execute the trigger
ELSIF the triggering row's legislation code, business group or payroll matches that of any functional area usage for any area to which the trigger belongs THEN
execute the trigger
ELSE
the trigger belongs to a functional area that is not enabled for the triggering record's context, so don't fire the trigger
END IF
This logic (or rather the opposite of it) is encapsulated in the ''paywsfgt_pkg.trigger_is_not_enabled'' function which all triggers call to determine whether or not they should execute their logic.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_FUNCTIONAL_USAGES_PK

USAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_FUNCTIONAL_USAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	USAGE_ID
PAY_FUNCTIONAL_TRIGGERS_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AREA_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_FUNCTIONAL_USAGES		PAY_FUNCTIONAL_AREAS	PAY_FUNCTIONAL_USAGES AREA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
USAGE_ID	NUMBER	(15)	Yes	System-generated primary key column.
AREA_ID	NUMBER	(15)	Yes	Foreign key to PAY_FUNCTIONAL_AREAS.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code. Set if seeded data.
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group which created the data.
PAYROLL_ID	NUMBER	(9)		Foreign key to PAY_ALL_PAYROLLS_F.
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.

Query Text

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


SELECT USAGE_ID
,      AREA_ID
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      PAYROLL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_FUNCTIONAL_USAGES;

Dependencies

[top of page]

HR.PAY_FUNCTIONAL_USAGES does not reference any database object

HR.PAY_FUNCTIONAL_USAGES is referenced by following:

APPS: PAY_FUNCTIONAL_USAGES; PAY_FUNCTIONAL_USAGES_WHO
PUBLIC: PAY_FUNCTIONAL_USAGES