The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Cursor select all projects from CC account lines table */
CURSOR c_acct_info IS
SELECT DISTINCT project_id
FROM igc_cc_acct_lines
WHERE cc_acct_line_id IN
(SELECT cc_acct_line_id
FROM igc_cc_interface_v a
WHERE cc_header_id = p_header_id
AND budget_dest_flag = 'C'
AND actual_flag = p_actual_flag
AND document_type = p_doc_type )
AND project_id IS NOT NULL ;
UPDATE igc_cc_interface_v v1
SET v1.pa_flag = 'Y',
v1.result_code_source = 'P',
v1.period_name =
( SELECT min(per.period_name)
FROM gl_period_statuses per
WHERE per.application_id = 101
AND per.adjustment_period_flag='N'
AND per.set_of_books_id = p_sobid
AND v1.cc_transaction_date
BETWEEN per.start_date
AND per.end_date
)
WHERE cc_header_id = p_header_id
AND budget_dest_flag = 'C'
AND actual_flag = p_actual_flag
AND document_type = p_doc_type
AND cc_acct_line_id IN
(SELECT cc_acct_line_id
FROM igc_cc_acct_lines
WHERE cc_header_id = p_header_id
AND project_id = c_acct_info_rec.project_id
AND project_id IS NOT NULL);
END LOOP; --End of interface update
SELECT distinct cbc_result_code, cc_header_id
FROM igc_cc_interface
WHERE cc_header_id = p_header_id;
SELECT distinct severity_rank INTO l_sev_rank
FROM igc_cc_result_code_ranks
WHERE funds_checker_code = l_result_code.cbc_result_code;
SELECT distinct popup_messg_code INTO l_h_code
FROM igc_cc_result_code_ranks
WHERE severity_rank = l_min_sev_rank
AND action = decode(p_mode,'F','R',p_mode);
SELECT min(IGC_CBC_FUNDS_CHECKER.Get_Rank(cbc_result_code))
INTO l_rank
FROM igc_cc_interface_v
WHERE cc_header_id = p_header_id
AND budget_dest_flag = 'C'
AND actual_flag = p_actual_flag
AND document_type = p_doc_type
AND cbc_result_code IS NOT NULL;
SELECT count(DISTINCT CODE_COMBINATION_ID)
FROM igc_cc_interface_v a
WHERE cc_header_id = p_header_id
AND budget_dest_flag = 'C'
AND actual_flag = p_actual_flag
AND document_type = p_doc_type
AND pa_flag ='Y'
HAVING count(DISTINCT CODE_COMBINATION_ID) > 1
GROUP BY cc_acct_line_id;