DBA Data[Home] [Help]

APPS.WF_BES_FUNCS dependencies on WF_EVENT_SUBSCRIPTIONS

Line 272: from wf_events we,wf_event_subscriptions wes

268: select distinct upper(trim(v.function)) function
269: from (
270: select upper(substr(wes.rule_function,1,instr(wes.rule_function, '.')-1)) package_name,
271: wes.rule_function function
272: from wf_events we,wf_event_subscriptions wes
273: where we.guid = wes.event_filter_guid and
274: instr(upper(we.name),p_corrid)=1 and
275: wes.rule_function is not null and
276: upper(wes.rule_function) not like 'WF_RULE%' and

Line 288: from wf_events we,wf_event_subscriptions wes

284: select distinct upper(trim(v.function)) function
285: from (
286: select upper(substr(wes.rule_function,1,instr(wes.rule_function, '.')-1)) package_name,
287: wes.rule_function function
288: from wf_events we,wf_event_subscriptions wes
289: where we.guid = wes.event_filter_guid and
290: wes.rule_function is not null and
291: (
292: upper(wes.rule_function) like 'WF_RULE%' or