4: FUNCTION exist_subscription(p_event_name IN VARCHAR2) RETURN VARCHAR2
5: IS
6: CURSOR cu0 IS
7: SELECT 'Y' 8: FROM wf_events eve, 9: wf_event_subscriptions sub
10: WHERE eve.name = p_event_name
11: AND eve.status = 'ENABLED'
12: AND eve.guid = sub.event_filter_guid
Line 45: FROM wf_events
41: IS
42: RetEvent VARCHAR2(240);
43: CURSOR get_event IS
44: SELECT name 45: FROM wf_events 46: WHERE name = p_event_name;
47: BEGIN
48: OPEN get_event;
49: