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_ACTION_PARAMETER_VALUES

Object Details

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

PAY_ACTION_PARAMETER_VALUES is the child table for
PAY_ACTION_PARAMETER_GROUPS and stores the values
of the action parameters for a specified group. This allows
the parameters to be striped for the user.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Unique Key: PAY_ACTION_PARAMETER_VALUES_UK

ACTION_PARAMETER_GROUP_ID
PARAMETER_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ACTION_PARAMETER_VALUES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_PARAMETER_GROUP_ID PARAMETER_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_NAME	VARCHAR2	(30)	Yes	Name of Parameter to Set
PARAMETER_VALUE	VARCHAR2	(80)	Yes	Value for a specific Parameter
ACTION_PARAMETER_GROUP_ID	NUMBER	(9)		Group_id of group of parameter value

Query Text

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


SELECT PARAMETER_NAME
,      PARAMETER_VALUE
,      ACTION_PARAMETER_GROUP_ID
FROM HR.PAY_ACTION_PARAMETER_VALUES;

Dependencies

[top of page]

HR.PAY_ACTION_PARAMETER_VALUES does not reference any database object

HR.PAY_ACTION_PARAMETER_VALUES is referenced by following:

APPS: PAY_ACTION_PARAMETERS_ARI; PAY_ACTION_PARAMETERS_ARU; PAY_ACTION_PARAMETER_VALUES
PUBLIC: PAY_ACTION_PARAMETER_VALUES