APPS.WF_BES_CACHE dependencies on WF_SYSTEMS

Line 59: FROM wf_systems

55: g_schema_name := wf_core.translate('WF_SCHEMA');
56: begin
57: SELECT name
58: INTO g_local_system_name
59: FROM wf_systems
60: WHERE guid = g_local_system_guid;
61: exception
62: when no_data_found then
63: g_local_system_name := null;

Line 701: FROM wf_agents a, wf_systems s

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

Line 710: FROM wf_agents a, wf_systems s

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

Line 800: FROM wf_agents a, wf_systems s

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