DBA Data[Home] [Help]

APPS.WF_EVENT_QH dependencies on WF_SYSTEMS

Line 178: wf_systems sys

174: select agt2.name ,agt2.address, agt2.protocol, agt2.queue_name
175: from wf_agent_groups agp ,
176: wf_agents agt1 ,
177: wf_agents agt2 ,
178: wf_systems sys
179: where agt1.name = agent_name
180: and agp.group_guid = agt1.guid
181: and agt1.type = 'GROUP'
182: and agt1.status = 'ENABLED'

Line 202: wf_systems sys

198:
199: -- Get Out Agent details --
200: select agt.queue_name into x_out_queue
201: from wf_agents agt,
202: wf_systems sys
203: where agt.name = x_out_agent_name
204: and sys.name = x_out_system_name
205: and sys.guid = agt.system_guid;
206: