VIEW: APPS.PAY_ENABLED_BUSINESS_GROUPS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )