APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_CLASSIFICATION_RULES

Line 224: select classification_rule_id, operation from CCT_CLASSIFICATION_RULES

220:
221: -- Declare program variables as shown above
222: BEGIN
223: FOR l_record IN (
224: select classification_rule_id, operation from CCT_CLASSIFICATION_RULES
225: where key in ('AccountCode','AccountNum','occtRoutePoint', 'ContractNum')
226: AND operation in ('=','>','>=','<','<=','!=','DOESNOTEXISTSIN','BETWEEN')
227: AND nvl(f_deletedflag,'N')<>'D'
228: )

Line 238: update CCT_CLASSIFICATION_RULES set operation=StringOperation

234: ELSIF UPPER(l_record.operation)='DOESNOTEXISTSIN' THEN
235: StringOperation:='DONOTEXISTIN';
236: END IF;
237:
238: update CCT_CLASSIFICATION_RULES set operation=StringOperation
239: where classification_rule_id = l_record.classification_rule_id;
240:
241: END LOOP;
242: --dbms_output.put_line('At End of 1st For Loop');