DBA Data[Home] [Help]

APPS.AS_BUSINESS_EVENT_PVT dependencies on WF_EVENTS

Line 75: FROM wf_events

71: IS
72: RetEvent VARCHAR2(240);
73: BEGIN
74: SELECT name INTO RetEvent
75: FROM wf_events
76: WHERE name = p_event_name;
77: IF SQL%NOTFOUND THEN
78: RetEvent := 'NOTFOUND';
79: END IF;

Line 92: FROM wf_events eve,

88: -----------------------------------------------------------------------
89: IS
90: CURSOR cu0 IS
91: SELECT 'Y'
92: FROM wf_events eve,
93: wf_event_subscriptions sub
94: WHERE eve.name = p_event_name
95: AND eve.status = 'ENABLED'
96: AND eve.guid = sub.event_filter_guid