APPS.WF_STANDARD dependencies on WF_AGENTS

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 3376: wf_agents wfa

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'
3380: and wfa.name not in ('WF_ERROR','WF_DEFERRED');