The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT external_application_id
FROM hr_ki_ext_applications
WHERE external_application_name = p_app_code;
select topic_id from hr_ki_topics where
topic_key=p_topic;
select integration_id from hr_ki_integrations where
integration_key =p_provider ;
select fnd_web_config.database_id into l_dbc from dual;
select fnd_profile.value('HR_KPI_AGENT') into l_hr_ext_servlet
from dual;
select fnd_profile.value('HR_KPI_GENFWK_SERVLET') into l_servlet
from dual;
select fnd_profile.value('APPS_SERVLET_AGENT') into
l_apps_servlet_agent from dual;
select SESSION_ID into l_session_id from icx_sessions where
icx_sessions.login_id = to_number(fnd_profile.value('LOGIN_ID'));
SELECT external_application_id
FROM hr_ki_ext_applications
WHERE external_application_name = p_app_code;
DELETE FROM hr_ki_ext_applications
WHERE external_application_name = p_app_code;
INSERT INTO hr_ki_ext_applications
(
ext_application_id,
external_application_name,
external_application_id
)
SELECT
hr_ki_ext_applications_s.nextval,
p_app_code,
l_app_id
FROM dual;
UPDATE hr_ki_ext_applications
SET external_application_id = l_app_id
WHERE external_application_name = p_app_code;