View: PAY_ENABLED_LEGISLATIONS_V

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

View Text

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 )

Columns