APPS.WF_EVENT_QH dependencies on WF_AGENTS

Line 22: from wf_agents

18:
19: begin
20: select upper(queue_name), upper(name)
21: into x_queue_name, x_agent_name
22: from wf_agents
23: where guid = p_agent_guid;
24:
25: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
26: wf_log_pkg.string(wf_log_pkg.level_procedure,

Line 159: wf_agents agt1 ,

155: --Cursor to select the to_agents for the recipient list
156: CURSOR recipients(agent_name varchar2,system_name varchar2) is
157: select agt2.name ,agt2.address, agt2.protocol, agt2.queue_name
158: from wf_agent_groups agp ,
159: wf_agents agt1 ,
160: wf_agents agt2 ,
161: wf_systems sys
162: where agt1.name = agent_name
163: and agp.group_guid = agt1.guid

Line 160: wf_agents agt2 ,

156: CURSOR recipients(agent_name varchar2,system_name varchar2) is
157: select agt2.name ,agt2.address, agt2.protocol, agt2.queue_name
158: from wf_agent_groups agp ,
159: wf_agents agt1 ,
160: wf_agents agt2 ,
161: wf_systems sys
162: where agt1.name = agent_name
163: and agp.group_guid = agt1.guid
164: and agt1.type = 'GROUP'

Line 184: from wf_agents agt,

180: end if;
181:
182: -- Get Out Agent details --
183: select agt.queue_name into x_out_queue
184: from wf_agents agt,
185: wf_systems sys
186: where agt.name = x_out_agent_name
187: and sys.name = x_out_system_name
188: and sys.guid = agt.system_guid;