APPS.CCT_IKEY_UPG dependencies on CCT_INTERACTION_KEYS

Line 12: FROM cct_interaction_keys

8: l_loop_count INTEGER := 0;
9: BEGIN
10: BEGIN
11: SELECT Count(*) INTO l_upgraded
12: FROM cct_interaction_keys
13: WHERE interaction_key_id = 7 and interaction_key='PARTY_ID' ;
14: EXCEPTION
15: When Others Then
16: status := SQLCODE;

Line 25: update cct_interaction_keys set interaction_key='PARTY_ID' where interaction_key_id = 7;

21: --dbms_output.put_line('CustomerID is Already Upgraded');
22: return;
23: END IF;
24:
25: update cct_interaction_keys set interaction_key='PARTY_ID' where interaction_key_id = 7;
26: update CCT_CLASSIFICATION_RULES set key='PARTY_ID' where nvl(f_deletedflag,'N')<>'D' and key='CustomerID';
27: --Since cct_route_params also stores dynamic route's plsql param, "sequence is not null" determines
28: --that we are updating plsql params only.
29: update cct_route_params set value='PARTY_ID' where value='CustomerID' and sequence is not null and nvl(f_deletedflag,'N')<>'D';