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_DEFINED_BALANCES_V2

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_DEFINED_BALANCES_V2

View Text

SELECT DB.ROWID ROW_ID
, DB.DEFINED_BALANCE_ID
, DB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, DB.LEGISLATION_CODE
, DB.BALANCE_TYPE_ID
, DB.BALANCE_DIMENSION_ID
, DB.FORCE_LATEST_BALANCE_FLAG
, DB.LEGISLATION_SUBGROUP
, DB.LAST_UPDATE_DATE
, DB.LAST_UPDATED_BY
, DB.LAST_UPDATE_LOGIN
, DB.CREATED_BY
, DB.CREATION_DATE
, BD.DIMENSION_NAME
, BD.DESCRIPTION DIMENSION_DESCRIPTION
, BDT.DIMENSION_NAME TL_DIMENSION_NAME
, BDT.DESCRIPTION TL_DIMENSION_DESCRIPTION
, DB.GROSSUP_ALLOWED_FLAG
FROM PAY_DEFINED_BALANCES DB
, PAY_BALANCE_DIMENSIONS BD
, PAY_BALANCE_DIMENSIONS_TL BDT
WHERE BD.BALANCE_DIMENSION_ID = DB.BALANCE_DIMENSION_ID
AND BDT.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID
AND BDT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
DEFINED_BALANCE_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
BALANCE_TYPE_ID
BALANCE_DIMENSION_ID
FORCE_LATEST_BALANCE_FLAG
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
DIMENSION_NAME
DIMENSION_DESCRIPTION
TL_DIMENSION_NAME
TL_DIMENSION_DESCRIPTION
GROSSUP_ALLOWED_FLAG