APPS.PER_PRT_BUS SQL Statements

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

Line: 15

procedure chk_non_updateable_args(p_rec in per_prt_shd.g_rec_type) is

  l_proc	varchar2(72)	:= g_package||'chk_non_updateable_args';

Line: 60

end chk_non_updateable_args;

Line: 107

    select null
      from per_appraisals
     where appraisal_id = p_appraisal_id;

Line: 217

    select o.business_group_id
      from per_objectives o
     where o.objective_id = p_objective_id;

Line: 222

    select null
      from per_appraisals a
     where a.appraisal_id = p_appraisal_id
       and a.business_group_id = l_business_group_id;

Line: 228

    select null
      from per_performance_ratings p
     where objective_id = p_objective_id
       and appraisal_id = p_appraisal_id;

Line: 378

    select r.business_group_id
      from per_rating_levels r
     where r.rating_level_id = p_performance_level_id;

Line: 385

    select null
      from per_appraisals a
     where a.appraisal_id = p_appraisal_id
       and a.business_group_id = l_business_group_id;

Line: 393

    select null
      from per_rating_levels r,
           per_appraisal_templates t,
           per_appraisals p,
           per_assessment_types a
     where p.appraisal_id = p_appraisal_id
       and p.appraisal_template_id = t.appraisal_template_id
       and t.objective_asmnt_type_id = a.assessment_type_id(+)
       and r.rating_scale_id = decode(t.objective_asmnt_type_id, null, t.rating_scale_id, a.rating_scale_id)
       and r.rating_level_id = p_performance_level_id;

Line: 563

    select 'Y'
      from per_performance_ratings ppr
     where ppr.appraisal_id = p_appraisal_id
       and ppr.objective_id = p_objective_id
       and ppr.person_id = p_person_id;

Line: 755

Procedure insert_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is

  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 821

End insert_validate;

Line: 826

Procedure update_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is

  l_proc  varchar2(72) := g_package||'update_validate';

Line: 848

  chk_non_updateable_args(p_rec);

Line: 869

End update_validate;

Line: 874

Procedure delete_validate(p_rec in per_prt_shd.g_rec_type) is

  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 885

End delete_validate;

Line: 897

          select legislation_code
          from   per_business_groups      pbg,
                 per_performance_ratings  ppr,
                 per_objectives           pob
          where  ppr.performance_rating_id = p_performance_rating_id
            and  ppr.objective_id          = pob.objective_id
            and  pbg.business_group_id     = pob.business_group_id;

Line: 948

    SELECT performance_rating_id, object_version_number
    FROM   per_performance_ratings
    WHERE  objective_id    = p_objective_id;