DBA Data[Home] [Help]

APPS.WF_BES_FUNCS dependencies on WF_EVENTS

Line 259: from wf_events we

255: select distinct upper(trim(v.function)) function
256: from (
257: select upper(substr(we.generate_function,1,instr(we.generate_function, '.')-1)) package_name,
258: we.generate_function function
259: from wf_events we
260: where we.generate_function is not null and
261: instr(upper(we.name),p_corrid)=1
262: ) v, user_objects uo
263: where uo.object_name = nvl(v.package_name,v.function) and

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