View: PAY_CA_SUPP_EARNINGS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CA_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_ELEMENT_TYPES_F PET
, PAY_ELEMENT_CLASSIFICATIONS PEC
WHERE PEC.CLASSIFICATION_NAME = 'SUPPLEMENTAL EARNINGS'
AND PEC.LEGISLATION_CODE = 'CA'
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.BUSINESS_GROUP_ID = PBT.BUSINESS_GROUP_ID
AND PET.ELEMENT_INFORMATION10 IS NOT NULL
AND PBT.BALANCE_TYPE_ID = PET.ELEMENT_INFORMATION10
AND PBTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBTL.LANGUAGE = USERENV('LANG')

Columns