APPS.WF_STANDARD dependencies on WF_AGENTS

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

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