VIEW: APPS.PAY_GB_PAYSLIP_BALANCE_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'