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_PAY_ELEMENT_DISTRIBUTION

Object Details

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

View Type

A Business Intelligence System view

PSBBV_PAY_ELEMENT_DISTRIBUTION displays the cost distribution rules for a pay element. Different distribution rules can be defined for groups of position sets for a given element. For example, medical benefits can be distributed differently for full-time employees and part-time employees. For all salary elements, cost distribution must be defined. For non-salary elements, independent distribution rules can be defined, or the distribution rule can be defined to follow the salary distribution rules. If the distribution rule is set to follow salary, then only the override segment values are defined for the given element. The cost calculated for these dependent elements is distributed to accounts derived by substituting the override segment values in the same proportion as the salary.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
_KF:GL_ACCOUNT	CHAR	(17)		Key Flexfield segments placeholder. This column is expanded into multiple columns for each segment of the Key Flexfield during view generation.
DISTRIBUTION_PERCENT	NUMBER			Distribution percentage
DISTRIBUTION_ID	NUMBER	(15)	Yes	Distribution unique identifier
POSITION_SET_GROUP_ID	NUMBER	(15)	Yes	Position set group associated with the pay element distribution
CODE_COMBINATION_ID	NUMBER	(15)		General Ledger code combination identifier for the distribution
DISTRIBUTION_SET_ID	NUMBER	(15)	Yes	Group account distribution lines for a date range for an element not following salary
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 START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _KF:GL_ACCOUNT
,      DISTRIBUTION_PERCENT
,      DISTRIBUTION_ID
,      POSITION_SET_GROUP_ID
,      CODE_COMBINATION_ID
,      DISTRIBUTION_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_PAY_ELEMENT_DISTRIBUTION;

Dependencies

[top of page]

APPS.PSBBV_PAY_ELEMENT_DISTRIBUTION references the following:

APPS: GL_CODE_COMBINATIONS; PSB_PAY_ELEMENT_DISTRIBUTIONS

APPS.PSBBV_PAY_ELEMENT_DISTRIBUTION is not referenced by any database object