APPS.WF_ENGINE dependencies on WF_EVENTS

Line 6749: FROM WF_EVENTS WE

6745: AND WA.DIRECTION = 'RECEIVE'
6746: AND (WA.EVENT_NAME is null
6747: OR WA.EVENT_NAME in
6748: (SELECT WE.NAME -- Single events
6749: FROM WF_EVENTS WE
6750: WHERE WE.TYPE = 'EVENT'
6751: AND WE.NAME = event.event_name
6752: UNION ALL
6753: SELECT GRP.NAME -- Groups containing event

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

6750: WHERE WE.TYPE = 'EVENT'
6751: AND WE.NAME = event.event_name
6752: UNION ALL
6753: SELECT GRP.NAME -- Groups containing event
6754: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6755: WHERE GRP.TYPE = 'GROUP'
6756: AND GRP.GUID = WEG.GROUP_GUID
6757: AND WEG.MEMBER_GUID = MBR.GUID
6758: AND MBR.NAME = event.event_name));

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

6982: WA.EVENT_NAME = event2.event_name OR
6983: EXISTS
6984: (
6985: SELECT null -- Groups containing event
6986: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6987: WHERE GRP.TYPE = 'GROUP'
6988: AND GRP.GUID = WEG.GROUP_GUID
6989: AND WEG.MEMBER_GUID = MBR.GUID
6990: AND MBR.NAME = event2.event_name