APPS.WF_BES_CACHE dependencies on WF_AGENTS

Line 705: FROM wf_agents a, wf_systems s

701: CURSOR c_get_agent_n (cp_agent_name varchar2, cp_system_name varchar2) IS
702: SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
703: a.queue_handler, a.queue_name, a.direction, a.status,
704: a.display_name, a.type, a.java_queue_handler
705: FROM wf_agents a, wf_systems s
706: WHERE a.name = cp_agent_name
707: AND a.system_guid = s.guid
708: AND s.name = cp_system_name;
709:

Line 714: FROM wf_agents a, wf_systems s

710: CURSOR c_get_agent_g (cp_agent_guid raw) IS
711: SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
712: a.queue_handler, a.queue_name, a.direction, a.status,
713: a.display_name, a.type, a.java_queue_handler
714: FROM wf_agents a, wf_systems s
715: WHERE a.guid = cp_agent_guid
716: AND s.guid = a.system_guid;
717:
718: begin

Line 804: FROM wf_agents a, wf_systems s

800: CURSOR c_get_agent (cp_agent_qh varchar2, cp_direction varchar2) IS
801: SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
802: a.queue_handler, a.queue_name, a.direction, a.status,
803: a.display_name, a.type, a.java_queue_handler
804: FROM wf_agents a, wf_systems s
805: WHERE a.system_guid = wf_event.local_system_guid
806: AND a.system_guid = s.guid
807: AND a.queue_handler = cp_agent_qh
808: AND a.direction = cp_direction;