SELECT FTL.LEGISLATION_CODE , FTL.LEGISLATION_NAME FROM (SELECT TERRITORY_CODE LEGISLATION_CODE , TERRITORY_SHORT_NAME LEGISLATION_NAME FROM FND_TERRITORIES_VL UNION SELECT '-1' LEGISLATION_CODE , '' LEGISLATION_NAME FROM DUAL) FTL WHERE EXISTS( SELECT 'X' FROM PAY_FUNCTIONAL_USAGES PFU WHERE PFU.LEGISLATION_CODE = FTL.LEGISLATION_CODE )