The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
B.COUNTER_PROPERTY_ID ,
B.COUNTER_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTERS_ACC CACC
WHERE B.COUNTER_ID = CACC.COUNTER_ID
AND CACC.USER_ID = c_user_id
AND CACC.COUNTER_ID = c_counter_id
AND NOT EXISTS( SELECT 1
FROM CSM_COUNTER_PROPERTIES_ACC PACC
WHERE PACC.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID
AND PACC.USER_ID = c_user_id);
CSM_ACC_PKG.Insert_Acc
( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
,P_ACC_TABLE_NAME => g_count_prp_acc_table_name
,P_SEQ_NAME => g_count_prp_seq_name
,P_PK1_NAME => g_count_prp_pk1_name
,P_PK1_NUM_VALUE => r_cntr_prp_rec.counter_property_id
,P_USER_ID => p_user_id
);
SELECT
PACC.ACCESS_ID ,
PACC.USER_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTER_PROPERTIES_ACC PACC
WHERE B.COUNTER_PROPERTY_ID = PACC.COUNTER_PROPERTY_ID
AND PACC.USER_ID = c_user_id
AND B.COUNTER_ID = c_counter_id;
SELECT
PACC.ACCESS_ID ,
B.COUNTER_PROPERTY_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTER_PROPERTIES_ACC PACC
WHERE B.COUNTER_PROPERTY_ID = PACC.COUNTER_PROPERTY_ID
AND PACC.USER_ID = c_user_id
AND B.COUNTER_ID = c_counter_id;
CSM_ACC_PKG.Delete_Acc
( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
,P_ACC_TABLE_NAME => g_count_prp_acc_table_name
,P_PK1_NAME => g_count_prp_pk1_name
,P_PK1_NUM_VALUE => r_cntr_prp_rec.counter_property_id
,P_USER_ID => p_user_id
);