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]

VIEW: APPS.PSBBV_DEFAULT_ASSIGNMENTS

Object Details

Object Name:	PSBBV_DEFAULT_ASSIGNMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSBBV_DEFAULT_ASSIGNMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PSBBV_DEFAULT_ASSIGNMENTS displays information about default attributes and element assignments for a position. The assignment type indicates if this is an attribute or element assignment. If it is an element assignment, then an element and the corresponding element
option or element value are specified. If it is an attribute assignment, then an attribute and a corresponding attribute value are specified.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_VALUE	VARCHAR2	(240)		Value assigned for the attribute in this default assignment
_LA:ASSIGNMENT_TYPE	CHAR	(63)		Indicates if Attribute or Element assignment
_LA:PAY_BASIS	CHAR	(51)		Pay basis for the salary element
_LA:ELEMENT_VALUE_TYPE	CHAR	(69)		Element value type. Values are Amount, Formula, or Percent of Salary.
ELEMENT_VALUE	NUMBER			Value assigned for the element in this default assignment
CURRENCY_CODE	VARCHAR2	(10)		Currency code for the element value
DEFAULT_ASSIGNMENT_ID	NUMBER	(20)	Yes	Default assignment unique identifier
DEFAULT_RULE_ID	NUMBER	(20)	Yes	Default rule unique identifier. Default rule to which this assignment belongs.
ATTRIBUTE_ID	NUMBER	(15)		Attribute for which this assignment is made
ATTRIBUTE_VALUE_ID	NUMBER	(15)		Identifier of the attribute value assigned to this default assignment
PAY_ELEMENT_ID	NUMBER	(20)		Element for which the assignment is made if it is an element assignment
PAY_ELEMENT_OPTION_ID	NUMBER	(20)		Element option identifier assigned to the default rule if the element has an option table
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT ATTRIBUTE_VALUE
,      _LA:ASSIGNMENT_TYPE
,      _LA:PAY_BASIS
,      _LA:ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      CURRENCY_CODE
,      DEFAULT_ASSIGNMENT_ID
,      DEFAULT_RULE_ID
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_DEFAULT_ASSIGNMENTS;

Dependencies

[top of page]

APPS.PSBBV_DEFAULT_ASSIGNMENTS references the following:

APPS: PSB_DEFAULT_ASSIGNMENTS

APPS.PSBBV_DEFAULT_ASSIGNMENTS is not referenced by any database object