286: -- check if agent is available to process media item.
287:
288: declare cursor r1 is
289: select agent_id, raw_agent_index, item_type, classification 290: from cct_qde_agent_vw 291: where (item_type = p_item_type)
292: and ((classification is null) or (classification is not null
293: and classification = p_classification))
294: and (is_get_work = 1)