APPS.CCT_CALLCENTER_UTIL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

		Select m.middleware_id
		from cct_middlewares m,cct_telesets t,cct_agent_rt_stats a
		where a.agent_id=p_agent_id
		and a.client_id=t.teleset_id
		and t.middleware_id=m.middleware_id;

Line: 19

		Select upper(p.name),v.value
		from cct_middleware_params p,cct_middleware_values v,cct_middlewares m
		where m.middleware_id=p_middleware_id
		and m.middlewarE_type_id=p.middleware_type_id
		and p.middleware_param_id=v.middleware_param_id
		and nvl(v.f_deletedflag,'N')<>'D';