The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
integration_id
,integration_key
,party_type
,party_name
,party_site_name
,transaction_type
,transaction_subtype
,standard_code
,ext_trans_type
,ext_trans_subtype
,trans_direction
,url
,synched
,ext_application_id
,application_name
,application_type
,application_url
,logout_url
,user_field
,password_field
,authentication_needed
,field_name1
,field_value1
,field_name2
,field_value2
,field_name3
,field_value3
,field_name4
,field_value4
,field_name5
,field_value5
,field_name6
,field_value6
,field_name7
,field_value7
,field_name8
,field_value8
,field_name9
,field_value9
,object_version_number
from hr_ki_integrations
where integration_id = p_integration_id;
select
integration_id
,integration_key
,party_type
,party_name
,party_site_name
,transaction_type
,transaction_subtype
,standard_code
,ext_trans_type
,ext_trans_subtype
,trans_direction
,url
,synched
,ext_application_id
,application_name
,application_type
,application_url
,logout_url
,user_field
,password_field
,authentication_needed
,field_name1
,field_value1
,field_name2
,field_value2
,field_name3
,field_value3
,field_name4
,field_value4
,field_name5
,field_value5
,field_name6
,field_value6
,field_name7
,field_value7
,field_name8
,field_value8
,field_name9
,field_value9
,object_version_number
from hr_ki_integrations
where integration_id = p_integration_id
for update nowait;