APPS.WF_EVENT_QH dependencies on WF_SYSTEMS

Line 161: wf_systems sys

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'
165: and agt1.status = 'ENABLED'

Line 185: wf_systems sys

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;
189: