APPS.FND_OID_DIAG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 523: from wf_events e, wf_event_subscriptions s

519:
520: CURSOR c1(sub VARCHAR2) is
521:
522: select s.status, e.name
523: from wf_events e, wf_event_subscriptions s
524: where rule_function = sub and
525: s.event_filter_guid = e.guid;
526:
527: begin

Line 1199: from wf_event_subscriptions

1195: l_status varchar2(10);
1196:
1197: begin
1198: select status into l_status
1199: from wf_event_subscriptions
1200: where source_type = 'LOCAL' and
1201: rule_function = subName;
1202:
1203: return l_status;