31: --We assume that group members are of the same system as agent group.
32: CURSOR agent_group_members(agent_name varchar2,system_name varchar2) is
33: select agt2.name as agt_name,
34: agt2.queue_handler as queue_handler 35: from wf_agent_groups agp , 36: wf_agents agt1 ,
37: wf_agents agt2 ,
38: wf_systems sys
39: where agt1.name = agent_name
[Home] [Help]