APPS.CCT_CALLCENTER_UTIL_PUB dependencies on CCT_MIDDLEWARES

Line 12: from cct_middlewares m,cct_telesets t,cct_agent_rt_stats a

8:
9: Cursor c_agent_mware(p_agent_id Number)
10: Is
11: Select m.middleware_id
12: from cct_middlewares m,cct_telesets t,cct_agent_rt_stats a
13: where a.agent_id=p_agent_id
14: and a.client_id=t.teleset_id
15: and t.middleware_id=m.middleware_id;
16:

Line 20: from cct_middleware_params p,cct_middleware_values v,cct_middlewares m

16:
17: Cursor c_mware_params(p_middleware_id Number)
18: Is
19: Select upper(p.name),v.value
20: from cct_middleware_params p,cct_middleware_values v,cct_middlewares m
21: where m.middleware_id=p_middleware_id
22: and m.middlewarE_type_id=p.middleware_type_id
23: and p.middleware_param_id=v.middleware_param_id
24: and nvl(v.f_deletedflag,'N')<>'D';