APPS.CCT_SERVICEROUTING_PUB SQL Statements

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

Line: 33

   Loop through the table  and insert each agent into the CCT_TEMPAGENTS table.
*-----------------------------------------------------------------------*/
procedure Set_Customer_Filter (
	itemtype     in varchar2
	, itemkey    in varchar2
	, actid      in number
	, funmode    in varchar2
	, resultout  in out nocopy varchar2)
  IS
    l_proc_name   VARCHAR2(30) := 'Set_Customer_Filter';

Line: 101

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CS_CUSTOMER_FILTER' , l_agents_tbl);

Line: 166

          SELECT inventory_item_id
          INTO l_acct_rec.INVENTORY_ITEM_ID
          FROM csi_item_instances
          WHERE instance_id = l_customer_pdt_id ;

Line: 199

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CS_PRODUCT_FILTER' , l_agents_tbl);

Line: 258

	  Select incident_owner_id into l_agent_ID
       from cs_incidents_all_b
       where incident_number=l_RequestNum;

Line: 268

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CS_REQUEST_OWNER_FILTER' , l_agent_ID);