The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT recommendation_id,
case_folder_id,
credit_request_id,
credit_recommendation,
recommendation_value1,
recommendation_value2,
status,
credit_type,
recommendation_name,
appealed_flag
FROM ar_cmgt_cf_recommends
WHERE credit_request_id = nvl(p_credit_request_id, credit_request_id)
AND nvl(appealed_flag, 'N') = p_appealed_flag
AND case_folder_id = nvl(p_case_folder_id, case_folder_id );
SELECT credit_request_id, case_folder_id
INTO l_credit_request_id, l_case_folder_id
FROM ar_cmgt_case_folders
WHERE case_folder_id = nvl(p_case_folder_id, case_folder_id )
AND credit_request_id = nvl(p_credit_request_id, credit_request_id)
AND type = 'CASE'
AND status = 'CLOSED';
UPDATE ar_cmgt_cf_recommends
SET appealed_flag = NULL
WHERE case_folder_id = l_case_folder_id;
UPDATE ar_cmgt_cf_recommends
SET appealed_flag = 'Y'
WHERE recommendation_id = p_appealing_reco_tbl(i).recommendation_id;
ELSE -- table is not pupoltaed. Update all of the recommendations
-- first updates all of
UPDATE ar_cmgt_cf_recommends
SET appealed_flag = 'Y'
WHERE case_folder_id = l_case_folder_id;