DBA Data[Home] [Help]

APPS.HZ_EVENT_PKG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on

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,

Line 71: -- table wf_event_subscriptions for better performance.

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,

Line 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