APPS.CCT_QDE_PUB dependencies on CCT_QDE_ROUTE_RESULT_VW

Line 522: from cct_qde_route_result_vw

518: --dbms_output.put_line('GET_NEXT_ITEM: post select l_raw_agent_index= ' || l_raw_agent_index);
519: -- $$$$ change no NO_DATA_FOUND
520: declare cursor r1 is
521: select item_id, item_type, classification, route_result, is_route_to_all
522: from cct_qde_route_result_vw
523: where (item_type = p_item_type)
524: and ((p_classification is null) or (p_classification is not null
525: and classification = p_classification))
526: and ((is_route_to_all = 'Y') or

Line 731: from cct_qde_route_result_vw

727: -- end if;
728:
729: declare cursor r1 is
730: select item_id, item_type, classification, route_result, is_route_to_all
731: from cct_qde_route_result_vw
732: where (item_type = p_item_type)
733: order by classification;
734: begin
735: --dbms_output.put_line('UPDATE_AGENT_QUEUES: post declare cursor');