APPS.WF_STANDARD dependencies on WF_SYSTEMS

Line 2922: from wf_systems ws

2918: else
2919: -- Since no subscription found, look at from agent details
2920: begin
2921: select 'LOCAL' into l_source
2922: from wf_systems ws
2923: where ws.guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
2924: and ws.name = nvl(l_event_t.GetFromAgent().GetSystem(),ws.name);
2925: exception
2926: when no_data_found then

Line 3353: from wf_agents wfa, wf_systems wfs

3349: -- Get the Out Agent in the agent@system format
3350: if l_outagentguid is not null then
3351: select wfa.name||'@'||wfs.name
3352: into l_outagent
3353: from wf_agents wfa, wf_systems wfs
3354: where wfa.guid = l_outagentguid
3355: and wfa.system_guid = wfs.guid;
3356: end if;
3357:

Line 3361: from wf_agents wfa, wf_systems wfs

3357:
3358: -- Get the To Agent in the agent@system format
3359: select wfa.name||'@'||wfs.name
3360: into l_toagent
3361: from wf_agents wfa, wf_systems wfs
3362: where wfa.guid = l_toagentguid
3363: and wfa.system_guid = wfs.guid;
3364:
3365: -- Update the agent item attributes

Line 3407: from wf_systems wfs,

3403: l_agent varchar2(30);
3404:
3405: cursor c_return_agent is
3406: select wfa.name agent
3407: from wf_systems wfs,
3408: wf_agents wfa
3409: where wfs.name = l_system
3410: and wfa.status = 'ENABLED'
3411: and wfa.direction = 'IN'

Line 3857: l_sysName WF_SYSTEMS.NAME%TYPE := null;

3853: IS
3854:
3855: l_event wf_event_t;
3856: l_paramlist wf_parameter_list_t := null;
3857: l_sysName WF_SYSTEMS.NAME%TYPE := null;
3858: l_agent wf_agent_t := null ;
3859:
3860:
3861: begin