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_POSITION_ASSIGNMENTS

Object Details

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

View Type

A Business Intelligence System view

PSBBV_POSITION_ASSIGNMENTS displays all position element assignments.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_VALUE	NUMBER			Element value
_LA:ELEMENT_VALUE_TYPE	CHAR	(65)		Type of element value
CURRENCY_CODE	VARCHAR2	(15)		Currency code
_LA:PAY_BASIS	CHAR	(47)		Salary basis
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
POSITION_ID	NUMBER		Yes	Position unique identifier
POSITION_ASSIGNMENT_ID	NUMBER	(15)	Yes	Position assignment unique identifier
WORKSHEET_ID	NUMBER	(20)		Worksheet unique identifier. Null for base assignments or worksheet identifier for worksheet specific assignment.
PAY_ELEMENT_ID	NUMBER	(20)		Pay element identifier
PAY_ELEMENT_OPTION_ID	NUMBER	(20)		Pay element option identifier

Query Text

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


SELECT ELEMENT_VALUE
,      _LA:ELEMENT_VALUE_TYPE
,      CURRENCY_CODE
,      _LA:PAY_BASIS
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      POSITION_ID
,      POSITION_ASSIGNMENT_ID
,      WORKSHEET_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
FROM APPS.PSBBV_POSITION_ASSIGNMENTS;

Dependencies

[top of page]

APPS.PSBBV_POSITION_ASSIGNMENTS references the following:

APPS: PSB_POSITION_ASSIGNMENTS

APPS.PSBBV_POSITION_ASSIGNMENTS is not referenced by any database object