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.

[Home] [Help]

View: PAY_BALANCE_ATTRIBUTES_V

Product:	PAY - Payroll
Description:	Supports user interface for balance attributes
Implementation/DBA Data:	APPS.PAY_BALANCE_ATTRIBUTES_V

View Text

SELECT PBA.ROWID
, PBA.BALANCE_ATTRIBUTE_ID
, PBA.ATTRIBUTE_ID
, BAD.ATTRIBUTE_NAME
, PBA.DEFINED_BALANCE_ID
, PDB.BALANCE_TYPE_ID
, DIM.BALANCE_DIMENSION_ID
, DIM.DIMENSION_NAME
, PBA.LEGISLATION_CODE
, PBA.BUSINESS_GROUP_ID
, BAD.USER_ATTRIBUTE_NAME
, PBA.LAST_UPDATE_DATE
, PBA.LAST_UPDATED_BY
, PBA.LAST_UPDATE_LOGIN
, PBA.CREATED_BY
, PBA.CREATION_DATE
FROM PAY_BALANCE_ATTRIBUTES PBA
, PAY_BAL_ATTRIBUTE_DEFINITIONS BAD
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS DIM
WHERE PBA.ATTRIBUTE_ID = BAD.ATTRIBUTE_ID
AND PBA.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PDB.BALANCE_DIMENSION_ID = DIM.BALANCE_DIMENSION_ID

Columns

Name
ROW_ID
BALANCE_ATTRIBUTE_ID
ATTRIBUTE_ID
ATTRIBUTE_NAME
DEFINED_BALANCE_ID
BALANCE_TYPE_ID
BALANCE_DIMENSION_ID
DIMENSION_NAME
LEGISLATION_CODE
BUSINESS_GROUP_ID
USER_ATTRIBUTE_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE