APPS.CCT_SERVERGROUPROUTING_PUB dependencies on CCT_AGENT_RT_STATS

Line 40: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

36: ,p_agent_tbl OUT nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
37: )
38: RETURN number IS
39: l_total_num_of_agents NUMBER:=0;
40: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
41:
42:
43: CURSOR csr_agents IS
44: SELECT a.agent_id

Line 45: FROM cct_agent_rt_stats a

41:
42:
43: CURSOR csr_agents IS
44: SELECT a.agent_id
45: FROM cct_agent_rt_stats a
46: WHERE mcm_id = p_mcm_id;
47:
48:
49: BEGIN