View: PAY_ENABLED_PAYROLLS_V

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

View Text

SELECT PAP.PAYROLL_ID
, PAP.PAYROLL_NAME
FROM (SELECT PAYROLL_ID
, PAYROLL_NAME
FROM PAY_ALL_PAYROLLS UNION SELECT -1 PAYROLL_ID
, '' PAYROLL_NAME
FROM DUAL) PAP
WHERE EXISTS( SELECT 'X'
FROM PAY_FUNCTIONAL_USAGES PFU
WHERE PFU.PAYROLL_ID = PAP.PAYROLL_ID )

Columns