View: PAY_ENABLED_BUSINESS_GROUPS_V

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

View Text

SELECT PBG.BUSINESS_GROUP_ID
, PBG.NAME
FROM (SELECT BUSINESS_GROUP_ID
, NAME
FROM PER_BUSINESS_GROUPS UNION SELECT -1 BUSINESS_GROUP_ID
, '' NAME
FROM DUAL) PBG
WHERE EXISTS( SELECT 'X'
FROM PAY_FUNCTIONAL_USAGES PFU
WHERE PFU.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID )

Columns