APPS.CCT_SERVERGROUPROUTING_PUB SQL Statements

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

Line: 21

    select GRP.GROUP_NAME into l_servergroup_name
    from   IEO_SVR_GROUPS GRP, IEO_SVR_SERVERS svr
    where  grp.server_group_id=svr.member_svr_group_id
    and    svr.server_id=p_MCMID;

Line: 44

       SELECT a.agent_id
       FROM cct_agent_rt_stats a
	  WHERE mcm_id = p_mcm_id;

Line: 79

        Select def.application_id,decode(def.application_id,511,'TELESERVICE',
                                                            521,'TELESALES','OTHER')
        into p_app_id,p_app_name
        from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
        where act.maction_def_id=def.maction_def_id
	   and type.media_type_uuid=p_mediaTypeUUID
        and type.media_type_id=act.media_type_id
        and upper(act.classification)=upper(p_classification);

Line: 91

	        Select act.application_id,decode(act.application_id,511,'TELESERVICE',
	                                                            521,'TELESALES','OTHER')
	        into p_app_id,p_app_name
             from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
             where act.maction_def_id=def.maction_def_id
	        and type.media_type_uuid=p_mediaTypeUUID
             and type.media_type_id=act.media_type_id
	        and upper(act.classification)=upper('unClassified');

Line: 102

			        Select act.application_id,decode(act.application_id,511,'TELESERVICE',
			                                                            521,'TELESALES','OTHER')
			        into p_app_id,p_app_name
                       from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
                       where act.maction_def_id=def.maction_def_id
	                  and type.media_type_uuid=p_mediaTypeUUID
                       and type.media_type_id=act.media_type_id
			        and act.classification is null;