APPS.PER_MM_ASSIGNMENTS_PKG SQL Statements

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

Line: 5

procedure update_row
           (p_default_from in varchar2,
            p_select_assignment in varchar2,
            p_grade_id in number,
            p_tax_unit_id in number,
            p_row_id in varchar2)

  is
    begin
      update per_mm_assignments
         set default_from = p_default_from,
             select_assignment = p_select_assignment,
             grade_id = p_grade_id,
             tax_unit_id = p_tax_unit_id
       where rowid = p_row_id;

Line: 24

end update_row;

Line: 35

    select rule_mode
    from pay_legislation_rules plr,
         per_business_groups bg
    where plr.legislation_code = bg.legislation_code
    and bg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
    and rule_type = 'PERWSMMV_GRE';

Line: 51

     insert into per_mm_assignments
         (MASS_MOVE_ID,
          ASSIGNMENT_ID,
          OBJECT_VERSION_NUMBER,
          POSITION_ID,
          DEFAULT_FROM,
          SELECT_ASSIGNMENT,
          ASSIGNMENT_MOVED,
          GRADE_ID,
          TAX_UNIT_ID
          )
     select
         p_mass_move_id,
         asg.assignment_id,
         asg.object_version_number,
         asg.position_id,
         'A',
         'Y',
         'N',
         gra.grade_id,
         to_number(scl.segment1)
       from per_assignments_f asg,
            per_mm_positions mmpos,
            per_assignment_status_types stat,
            hr_soft_coding_keyflex scl,
            per_grades gra
        where asg.position_id = mmpos.position_id
        and mmpos.mass_move_id = p_mass_move_id
        and p_session_date between
            asg.effective_start_date and
            asg.effective_end_date
        and asg.grade_id = gra.grade_id (+)
        and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+)
        and stat.assignment_status_type_id =
            asg.assignment_status_type_id
        and stat.per_system_status in ('ACTIVE_ASSIGN'
                                      ,'ACTIVE_APL'
                                      ,'ACCEPTED'
                                      ,'ACTIVE_CWK')
        and asg.assignment_type in ('E','A','C');

Line: 94

         insert into per_mm_assignments
         (MASS_MOVE_ID,
          ASSIGNMENT_ID,
          OBJECT_VERSION_NUMBER,
          POSITION_ID,
          DEFAULT_FROM,
          SELECT_ASSIGNMENT,
          ASSIGNMENT_MOVED,
          GRADE_ID,
          TAX_UNIT_ID
          )
     select
         p_mass_move_id,
         asg.assignment_id,
         asg.object_version_number,
         asg.position_id,
         'A',
         'Y',
         'N',
         gra.grade_id,
         null
       from per_assignments_f asg,
            per_mm_positions mmpos,
            per_assignment_status_types stat,
            per_grades gra
        where asg.position_id = mmpos.position_id
        and mmpos.mass_move_id = p_mass_move_id
        and p_session_date between
            asg.effective_start_date and
            asg.effective_end_date
        and asg.grade_id = gra.grade_id (+)
        and stat.assignment_status_type_id =
            asg.assignment_status_type_id
        and stat.per_system_status in ('ACTIVE_ASSIGN'
                                      ,'ACTIVE_APL'
                                      ,'ACCEPTED'
                                      ,'ACTIVE_CWK')
        and asg.assignment_type in ('E','A','C');

Line: 151

            p_select_assignment in varchar2,
            p_grade_id in number,
            p_tax_unit_id in number,
            p_row_id in varchar2)

 is
    counter number;

Line: 159

      select *
        from per_mm_assignments
       where rowid = p_row_id
         for update of select_assignment nowait;

Line: 188

                (recinfo.select_assignment = p_select_assignment)
                 OR (    (recinfo.select_assignment is null)
                   AND (p_select_assignment is null)))
            AND(
                (recinfo.grade_id = p_grade_id)
                 OR (    (recinfo.grade_id is null)
                   AND (p_grade_id is null)))
            AND(
                (recinfo.tax_unit_id = p_tax_unit_id)
                 OR (    (recinfo.tax_unit_id is null)
                   AND (p_tax_unit_id is null)))
            ) then
            return;

Line: 238

        select grade_id,
               grade_name,
               tax_unit_id,
               tax_unit_name
        from per_mm_assignments_v
        where mass_move_id = p_mass_move_id
        and   assignment_id = p_assignment_id;