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.PSBFV_PAY_ELEMENT_DISTRIBUTION

Object Details

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

View Type

A Business Intelligence System view

PSBFV_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
PAY_ELEMENT_NAME	VARCHAR2	(30)	Yes	Pay element associated to the distribution
POSITION_SET_GROUP_NAME	VARCHAR2	(100)	Yes	Name of the position set group associated with the pay element distribution
START_EFFECTIVE_DATE	NUMBER	(15)	Yes	Effective start date
END_EFFECTIVE_DATE	NUMBER	(15)	Yes	Effective end date
_KF:GL_ACCOUNT	NUMBER	(15)	Yes	Key Flexfield segments placeholder. Column is expanded into multiple columns for each segment of the Key Flexfield during view generation.
DISTRIBUTION_PERCENT	DATE		Yes	Distribution percentage
POSITION_SET_GROUP_ID	DATE			Position set group associated with the pay element distribution
PAY_ELEMENT_ID	NUMBER	(15)		Pay element unique identifier
DISTRIBUTION_ID	CHAR	(17)		Distribution unique identifier
CODE_COMBINATION_ID	NUMBER			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 PAY_ELEMENT_NAME
,      POSITION_SET_GROUP_NAME
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _KF:GL_ACCOUNT
,      DISTRIBUTION_PERCENT
,      POSITION_SET_GROUP_ID
,      PAY_ELEMENT_ID
,      DISTRIBUTION_ID
,      CODE_COMBINATION_ID
,      DISTRIBUTION_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_PAY_ELEMENT_DISTRIBUTION;

Dependencies

[top of page]

APPS.PSBFV_PAY_ELEMENT_DISTRIBUTION references the following:

APPS: GL_CODE_COMBINATIONS_KFV; PSB_ELEMENT_POS_SET_GROUPS; PSB_PAY_ELEMENTS; PSB_PAY_ELEMENT_DISTRIBUTIONS

APPS.PSBFV_PAY_ELEMENT_DISTRIBUTION is not referenced by any database object