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 )
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
, '
FROM DUAL) FTL
WHERE EXISTS( SELECT 'X'
FROM PAY_FUNCTIONAL_USAGES PFU
WHERE PFU.LEGISLATION_CODE = FTL.LEGISLATION_CODE )
|
|
|