APPS.CCT_INTERACTION_KEY_UPG dependencies on CCT_ROUTE_PARAMS

Line 29: select route_param_id, value, operation from cct_route_params

25: END IF;
26:
27:
28: FOR l_record IN (
29: select route_param_id, value, operation from cct_route_params
30: where nvl(f_deletedflag,'N') <> 'D' )
31: LOOP
32: l_operation := 'EQUAL';
33: IF ((l_record.value = 'AccountCode') OR (l_record.value = 'ContractNum')

Line 43: update cct_route_params set operation = l_operation

39: ELSIF (l_record.operation = 'EXISTSIN') THEN
40: l_operation := 'EXISTSIN';
41: END IF;
42:
43: update cct_route_params set operation = l_operation
44: where route_param_id = l_record.route_param_id AND nvl(f_deletedflag,'N')<>'D';
45:
46: END IF;
47: END LOOP;