APPS.CCT_IKEY_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_id = 7 and interaction_key='PARTY_ID' ;

Line: 25

    update cct_interaction_keys set interaction_key='PARTY_ID' where interaction_key_id = 7;

Line: 26

    update CCT_CLASSIFICATION_RULES set key='PARTY_ID' where nvl(f_deletedflag,'N')<>'D' and key='CustomerID';

Line: 29

    update cct_route_params set value='PARTY_ID' where value='CustomerID' and sequence is not null and nvl(f_deletedflag,'N')<>'D';

Line: 30

    update cct_route_params set param='PARTY_ID' where param='CustomerID' and sequence is not null and nvl(f_deletedflag,'N')<>'D';

Line: 31

    update cct_plsql_function_params set value='PARTY_ID' where value='CustomerID' and nvl(f_deletedflag,'N')<>'D' ;