View: PAY_PURGE_ROLLUP_BALANCES_V

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

View Text

SELECT (BTTL.BALANCE_NAME || BM.DATABASE_ITEM_SUFFIX) BAL_FULL_NAME
, BTTL.BALANCE_NAME
, PRG.ASSIGNMENT_ACTION_ID
, PRG.DEFINED_BALANCE_ID
, PRG.JURISDICTION_CODE
, PRG.ORIGINAL_ENTRY_ID
, PRG.TAX_UNIT_ID
, PRG.VALUE
FROM PAY_BALANCE_TYPES_TL BTTL
, PAY_BALANCE_TYPES BT
, PAY_DEFINED_BALANCES BD
, PAY_BALANCE_DIMENSIONS BM
, PAY_PURGE_ROLLUP_BALANCES PRG
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND PRG.DEFINED_BALANCE_ID = BD.DEFINED_BALANCE_ID
AND BT.BALANCE_TYPE_ID = BD.BALANCE_TYPE_ID
AND BD.BALANCE_DIMENSION_ID = BM.BALANCE_DIMENSION_ID

Columns