The following lines contain the word 'select', 'insert', 'update' or 'delete':
select element_type_id
from pay_element_types_f
where element_name = p_element_name;
select input_value_id
from pay_input_values_f
where element_type_id = p_element_type_id
and name = p_name;
hr_entry_api.insert_element_entry(
p_effective_start_date => l_start_date,
p_effective_end_date => l_end_date,
p_element_entry_id => l_element_entry_id,
p_assignment_id => p_assignment_id,
p_element_link_id => l_element_link_id,
p_creator_type => 'F',
p_entry_type => 'E',
p_num_entry_values => 9,
p_input_value_id_tbl => inp_value_id_tbl,
p_entry_value_tbl => scr_valuetbl);