48: --We assume that group members are of the same system as agent group.
49: CURSOR agent_group_members(agent_name varchar2,system_name varchar2) is
50: select agt2.name as agt_name,
51: agt2.queue_handler as queue_handler 52: from wf_agent_groups agp , 53: wf_agents agt1 ,
54: wf_agents agt2 ,
55: wf_systems sys
56: where agt1.name = agent_name
[Home] [Help]