The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id_flex_structure_name
INTO l_transaction_coa_name
FROM fnd_id_flex_structures_vl ffsvl
WHERE ffsvl.application_id = 101
AND ffsvl.id_flex_code = 'GL#'
AND ffsvl.id_flex_num = p_transaction_coa_id;
SELECT compile_status_code
,chart_of_accounts_id
,name
INTO l_compile_status_code
,l_tad_coa_id
,l_tad_name
FROM xla_tab_acct_defs_vl xtd
WHERE xtd.application_id = g_application_info.application_id
AND xtd.account_definition_code = p_account_definition_code
AND xtd.account_definition_type_code = p_account_definition_type_code
AND xtd.amb_context_code = l_amb_context_code;
SELECT id_flex_structure_name
INTO l_tad_coa_name
FROM fnd_id_flex_structures_vl ffsvl
WHERE ffsvl.application_id = 101
AND ffsvl.id_flex_code = 'GL#'
AND ffsvl.id_flex_num = l_tad_coa_id;