VIEW: APPS.PAY_ENABLED_PAYROLLS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )