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,
76: wf_systems ws
77: WHERE eve.name = p_event_name
78: AND eve.status = 'ENABLED'
112: IS
113: RetEvent VARCHAR2(240);
114: BEGIN
115: SELECT name INTO RetEvent
116: FROM wf_events
117: WHERE name = p_event_name;
118: IF SQL%NOTFOUND THEN
119: RetEvent := 'NOTFOUND';
120: END IF;