The following lines contain the word 'select', 'insert', 'update' or 'delete':
icx_sec.updateSessionContext(
p_application_id => p_resp_appl_id,
p_responsibility_id => p_responsibility_id,
p_security_group_id => p_security_group_id,
p_session_id => l_session_id,
p_transaction_id => l_transaction_id);
select upper(value) into l_language
from v$nls_parameters
where parameter='NLS_LANGUAGE';
SELECT language_code INTO x_language_Code
FROM fnd_languages
WHERE nls_language = l_language;