APPS.PER_AST_BUS SQL Statements

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

Line: 26

Procedure chk_non_updateable_args(p_rec in per_ast_shd.g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'chk_non_updateable_args';

Line: 66

end chk_non_updateable_args;

Line: 101

    select business_group_id from per_assessment_types
    where ((p_assessment_type_id is NULL)
      or   (p_assessment_type_id <> assessment_type_id))
      and name = p_name -- there is a duplicate name.
      and  nvl(type , 'COMPETENCE') = nvl(p_type , 'COMPETENCE')
      and p_business_group_id is  null
    union
    select business_group_id from per_assessment_types
    where ((p_assessment_type_id is NULL)
      or   (p_assessment_type_id <> assessment_type_id))
      and name = p_name -- there is a duplicate name.
      and  nvl(type , 'COMPETENCE') = nvl(p_type , 'COMPETENCE')
      and (business_group_id = p_business_group_id or business_group_id is null)
      and p_business_group_id is not null;

Line: 312

    select min(assessment_date) , max(assessment_date)
    from per_assessments ass
    where p_assessment_type_id = ass.assessment_type_id
    and (p_business_group_id = business_group_id or  p_business_group_id is null) ;

Line: 429

    select null
    from per_assessments
    where assessment_type_id = p_assessment_type_id
    and (p_business_group_id = business_group_id or  p_business_group_id is null) ;

Line: 474

    hr_utility.trace('The assessment_classification is being updated');

Line: 545

    select type,business_group_id
    from per_rating_scales
    where p_weighting_scale_id = rating_scale_id
    and  (nvl(p_business_group_id,-1) = nvl(business_group_id,-1) or business_group_id is null);

Line: 555

    select null
    from per_assessments
    where assessment_type_id = p_assessment_type_id
    and ( business_group_id = p_business_group_id or p_business_group_id is null) ;

Line: 747

    select type
    from per_rating_scales
    where p_rating_scale_id = rating_scale_id
    and  (nvl(p_business_group_id,-1) = nvl(business_group_id,-1) or business_group_id is null) ;

Line: 756

    select null
    from per_assessments
    where assessment_type_id = p_assessment_type_id
    and business_group_id = p_business_group_id;

Line: 1272

    select null
    from per_assessments
    where assessment_type_id = p_assessment_type_id;

Line: 1528

Procedure insert_validate
 (p_rec 		in per_ast_shd.g_rec_type
 ,p_effective_date	in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1772

  hr_utility.trace('finished insert_validate');

Line: 1774

End insert_validate;

Line: 1779

Procedure update_validate
  (p_rec in per_ast_shd.g_rec_type
  ,p_effective_date in date
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1825

  per_ast_bus.chk_non_updateable_args
    (p_rec	=>  p_rec);

Line: 1997

End update_validate;

Line: 2002

Procedure delete_validate(p_rec in per_ast_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 2022

End delete_validate;

Line: 2034

          select legislation_code
          from   per_business_groups  pbg,
                 per_assessment_types pat
          where  pat.assessment_type_id = p_assessment_type_id
            and  pbg.business_group_id  = pat.business_group_id;