DBA Data[Home] [Help]

APPS.CCT_ROUTINGACTIVITIES_PUB SQL Statements

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

Line: 591

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CCT_COMPETENCY_LANG_FILTER' , l_agents_tbl);
Line: 657

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CCT_COMPETENCY_KNOW_FILTER' , l_agents_tbl);
Line: 723

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CCT_COMPETENCY_PROD_FILTER' , l_agents_tbl);
Line: 788

      CCT_RoutingWorkflow_UTL.InsertResults
	(l_call_ID, 'CCT_COMPETENCY_PROD_FILTER' , l_agents_tbl);
Line: 911

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_LOGGED_IN_FILTER' , l_agents_tbl);
Line: 966

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_FROM_STAT_GRP_NAM_FILTER' , l_agents_tbl);
Line: 1020

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_FROM_STAT_GRP_NUM_FILTER' , l_agents_tbl);
Line: 1073

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_FROM_DYN_GRP_NAM_FILTER' , l_agents_tbl);
Line: 1125

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_FROM_DYN_GRP_NUM_FILTER' , l_agents_tbl);
Line: 1179

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_NOT_IN_STAT_GRP_NAM_FILTER' , l_agents_tbl);
Line: 1232

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_NOT_IN_STAT_GRP_NUM_FILTER' , l_agents_tbl);
Line: 1284

      CCT_RoutingWorkflow_UTL.InsertResults
     (l_call_ID, 'CCT_AGENTS_NOT_IN_DYN_GRP_NUM_FILTER' , l_agents_tbl);
Line: 1336

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