APPS.CCT_INTERACTION_KEY_UPG dependencies on CCT_CLASSIFICATION_RULES

Line 51: select classification_rule_id, key, operation from CCT_Classification_Rules

47: END LOOP;
48:
49:
50: FOR l_record IN (
51: select classification_rule_id, key, operation from CCT_Classification_Rules
52: where nvl(f_deletedflag,'N') <> 'D' )
53: LOOP
54: l_operation := 'EQUAL';
55: IF ((l_record.key = 'AccountCode') OR (l_record.key = 'ContractNum')

Line 65: update CCT_Classification_Rules set operation = l_operation

61: ELSIF (l_record.operation = 'EXISTSIN') THEN
62: l_operation := 'EXISTSIN';
63: END IF;
64:
65: update CCT_Classification_Rules set operation = l_operation
66: where classification_rule_id = l_record.classification_rule_id
67: AND nvl(f_deletedflag,'N')<>'D' ;
68:
69: END IF;