APPS.PER_MM_JOB_REQUIREMENTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

     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;

Line: 27

         hr_utility.set_message_token('PROCEDURE','insert_child_rows');