DBA Data[Home] [Help]

APPS.WF_STANDARD dependencies on WF_SYSTEMS

Line 2891: from wf_systems ws

2887: else
2888: -- Since no subscription found, look at from agent details
2889: begin
2890: select 'LOCAL' into l_source
2891: from wf_systems ws
2892: where ws.guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
2893: and ws.name = nvl(l_event_t.GetFromAgent().GetSystem(),ws.name);
2894: exception
2895: when no_data_found then

Line 3321: from wf_agents wfa, wf_systems wfs

3317: -- Get the Out Agent in the agent@system format
3318: if l_outagentguid is not null then
3319: select wfa.name||'@'||wfs.name
3320: into l_outagent
3321: from wf_agents wfa, wf_systems wfs
3322: where wfa.guid = l_outagentguid
3323: and wfa.system_guid = wfs.guid;
3324: end if;
3325:

Line 3329: from wf_agents wfa, wf_systems wfs

3325:
3326: -- Get the To Agent in the agent@system format
3327: select wfa.name||'@'||wfs.name
3328: into l_toagent
3329: from wf_agents wfa, wf_systems wfs
3330: where wfa.guid = l_toagentguid
3331: and wfa.system_guid = wfs.guid;
3332:
3333: -- Update the agent item attributes

Line 3375: from wf_systems wfs,

3371: l_agent varchar2(30);
3372:
3373: cursor c_return_agent is
3374: select wfa.name agent
3375: from wf_systems wfs,
3376: wf_agents wfa
3377: where wfs.name = l_system
3378: and wfa.status = 'ENABLED'
3379: and wfa.direction = 'IN'