APPS.WF_ENGINE dependencies on WF_EVENTS

Line 6680: FROM WF_EVENTS WE

6676: AND WA.DIRECTION = 'RECEIVE'
6677: AND (WA.EVENT_NAME is null
6678: OR WA.EVENT_NAME in
6679: (SELECT WE.NAME -- Single events
6680: FROM WF_EVENTS WE
6681: WHERE WE.TYPE = 'EVENT'
6682: AND WE.NAME = event.event_name
6683: UNION ALL
6684: SELECT GRP.NAME -- Groups containing event

Line 6685: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR

6681: WHERE WE.TYPE = 'EVENT'
6682: AND WE.NAME = event.event_name
6683: UNION ALL
6684: SELECT GRP.NAME -- Groups containing event
6685: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6686: WHERE GRP.TYPE = 'GROUP'
6687: AND GRP.GUID = WEG.GROUP_GUID
6688: AND WEG.MEMBER_GUID = MBR.GUID
6689: AND MBR.NAME = event.event_name));

Line 6916: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR

6912: WA.EVENT_NAME = event2.event_name OR
6913: EXISTS
6914: (
6915: SELECT null -- Groups containing event
6916: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6917: WHERE GRP.TYPE = 'GROUP'
6918: AND GRP.GUID = WEG.GROUP_GUID
6919: AND WEG.MEMBER_GUID = MBR.GUID
6920: AND MBR.NAME = event2.event_name