APPS.CCT_INTERACTION_KEY_UPG SQL Statements

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

Line: 11

        SELECT Count(*) INTO l_upgraded
        FROM cct_interaction_keys
        WHERE (interaction_key='AccountCode' and data_type='STRING') OR
			(interaction_key='ContractNum' and data_type='STRING') OR
			(interaction_key='AccountNum' and data_type='STRING') ;

Line: 29

 	select route_param_id, value, operation from cct_route_params
 		where nvl(f_deletedflag,'N') <> 'D' )
 LOOP
	l_operation := 'EQUAL';

Line: 43

    	  update cct_route_params set operation = l_operation
		where route_param_id = l_record.route_param_id AND nvl(f_deletedflag,'N')<>'D';

Line: 51

    select classification_rule_id, key, operation from CCT_Classification_Rules
        where nvl(f_deletedflag,'N') <> 'D' )
LOOP
   l_operation := 'EQUAL';

Line: 65

      update CCT_Classification_Rules set operation = l_operation
      where classification_rule_id = l_record.classification_rule_id
		AND nvl(f_deletedflag,'N')<>'D'  ;

Line: 71

	update cct_interaction_keys set data_type='STRING'
		where (interaction_key='AccountCode' or interaction_key='ContractNum'
									  or interaction_key='AccountNum');