The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into per_mm_job_requirements
(MASS_MOVE_ID,
ANALYSIS_CRITERIA_ID,
DELETE_FLAG)
select distinct
p_mass_move_id,
analysis_criteria_id,
'N'
from per_job_requirements jbr,
per_mm_positions mmpos
where mmpos.position_id = jbr.position_id
and mmpos.mass_move_id = p_mass_move_id;
hr_utility.set_message_token('PROCEDURE','insert_child_rows');