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_RESTRICTION_PARAMETERS

Object Details

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

PAY_RESTRICTION_PARAMETERS holds the list of restrictions that can be
applied to specific HRMS forms. These parameters are used to define
specific customizations that will restrict the display of data to
individual users. The form uses the restriction parameters and values
in the query where clause of a block.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_RESTRICTION_PARAMETERS_PK

APPLICATION_ID
FORM_NAME
RESTRICTION_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_RESTRICTION_PARAMETERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID FORM_NAME RESTRICTION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	The Oracle application ID.
FORM_NAME	VARCHAR2	(30)	Yes	The name of the form that can be customized.
RESTRICTION_CODE	VARCHAR2	(30)	Yes	The type of customization that can be applied.
MULTIPLE_RESTRICTIONS_FLAG	VARCHAR2	(30)	Yes	Indicates whether multiple restrictions apply.
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.
EXCLUDE_ALLOWED_FLAG	VARCHAR2	(30)		Indicates whether the Exclude functionality is enabled for the restriction parameter.

Query Text

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


SELECT APPLICATION_ID
,      FORM_NAME
,      RESTRICTION_CODE
,      MULTIPLE_RESTRICTIONS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      EXCLUDE_ALLOWED_FLAG
FROM HR.PAY_RESTRICTION_PARAMETERS;

Dependencies

[top of page]

HR.PAY_RESTRICTION_PARAMETERS does not reference any database object

HR.PAY_RESTRICTION_PARAMETERS is referenced by following:

APPS: PAY_RESTRICTION_PARAMETERS; PAY_RESTRICTION_PARAMETERS_WHO
PUBLIC: PAY_RESTRICTION_PARAMETERS