66: -- Otherwise it returns 'N'
67: -----------------------------------------------------------------------
68: IS
69: -- Bug 3784725 : Modify the cursor so that it can use index
70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
67: -----------------------------------------------------------------------
68: IS
69: -- Bug 3784725 : Modify the cursor so that it can use index
70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
75: wf_event_subscriptions sub,
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
75: wf_event_subscriptions sub,
76: wf_systems ws
77: WHERE eve.name = p_event_name
78: AND eve.status = 'ENABLED'
79: AND eve.guid = sub.event_filter_guid