View: PAY_GB_PAYSLIP_BALANCE_TYPES_V

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

View Text

SELECT '1' || PBT.BALANCE_TYPE_ID
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, PBT.BALANCE_NAME
FROM PAY_BALANCE_TYPES PBT
WHERE NVL(PBT.LEGISLATION_CODE
, 'GB') = 'GB'
AND PBT.BALANCE_NAME <> 'NI EMPLOYEE' UNION SELECT '2' || PBT.BALANCE_TYPE_ID
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, SUBSTR(PBT.BALANCE_NAME
, 1
, 3) || SUBSTR(PBT.BALANCE_NAME
, 6)
FROM PAY_BALANCE_TYPES PBT
WHERE PBT.LEGISLATION_CODE = 'GB'
AND SUBSTR(PBT.BALANCE_NAME
, 1
, 5) = 'NI D '
AND PBT.BALANCE_NAME <> 'NI D EMPLOYER'

Columns