APPS.CCT_MEDIA_QUEUE_PUB dependencies on CCT_AGENT_RT_STATS

Line 210: from cct_agent_rt_stats where attribute11 = l_root_server_group_id

206:
207: -- no of agents logged in for that media type
208:
209: select count(*) into l_agents_media_type
210: from cct_agent_rt_stats where attribute11 = l_root_server_group_id
211: and attribute1 = 'T' and media_type = l_media_type ;
212:
213: select count(*) into l_agents_any_media_type
214: from cct_agent_rt_stats where attribute11 = l_root_server_group_id

Line 214: from cct_agent_rt_stats where attribute11 = l_root_server_group_id

210: from cct_agent_rt_stats where attribute11 = l_root_server_group_id
211: and attribute1 = 'T' and media_type = l_media_type ;
212:
213: select count(*) into l_agents_any_media_type
214: from cct_agent_rt_stats where attribute11 = l_root_server_group_id
215: and attribute1 = 'T' and media_type = l_media_type_any;
216:
217:
218: IF (x_abs_pos_media_type > 0) THEN

Line 246: select count(*) into l_agents_all_media_types from cct_agent_rt_stats

242: END IF;
243:
244: -- x_relative_pos_all_media_types = x_abs_pos_all_media_types / l_agents_all_media_types
245:
246: select count(*) into l_agents_all_media_types from cct_agent_rt_stats
247: where attribute1 = 'T' and attribute11= l_root_server_group_id;
248:
249: IF (x_abs_pos_all_media_types > 0) THEN
250: IF (l_agents_all_media_types > 0) THEN