View: PAY_CA_RB_SUPP_EARNINGS_V

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

View Text

SELECT PBT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, PBTL.BALANCE_NAME
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTL
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_BAL_ATTRIBUTE_DEFINITIONS PAD
WHERE PAD.ATTRIBUTE_NAME = 'PAY_CA_BPS_SUPP_EARNINGS'
AND PAD.LEGISLATION_CODE = 'CA'
AND PAD.ATTRIBUTE_ID = PBA.ATTRIBUTE_ID
AND PBA.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBTL.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 'X'
FROM PAY_BALANCE_DIMENSIONS
WHERE BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND LEGISLATION_CODE = 'CA'
AND DATABASE_ITEM_SUFFIX = '_ASG_GRE_RUN')

Columns