View: PAY_BALANCE_DEFINED_DIMENSIONS

Product:	PAY - Payroll
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PAY_BALANCE_DEFINED_DIMENSIONS

View Text

SELECT (BTTL.BALANCE_NAME || BM.DATABASE_ITEM_SUFFIX)
, BD.DEFINED_BALANCE_ID
, BT.BALANCE_TYPE_ID
, BM.BALANCE_DIMENSION_ID
, DECODE(ALB.DEFINED_BALANCE_ID
, NULL
, DECODE(PLB.DEFINED_BALANCE_ID
, NULL
, 'N'
, 'Y')
, 'Y')
FROM PAY_BALANCE_TYPES_TL BTTL
, PAY_BALANCE_TYPES BT
, PAY_DEFINED_BALANCES BD
, PAY_BALANCE_DIMENSIONS BM
, PAY_ASSIGNMENT_LATEST_BALANCES ALB
, PAY_PERSON_LATEST_BALANCES PLB
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND BT.BALANCE_TYPE_ID = BD.BALANCE_TYPE_ID
AND BD.BALANCE_DIMENSION_ID = BM.BALANCE_DIMENSION_ID
AND BD.DEFINED_BALANCE_ID = ALB.DEFINED_BALANCE_ID (+)
AND BD.DEFINED_BALANCE_ID = PLB.DEFINED_BALANCE_ID (+)

Columns