APPS.PER_RSL_BUS SQL Statements

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

Line: 39

    select pbg.security_group_id
      from per_business_groups pbg
         , per_rating_scales_tl rsl_tl
         , per_rating_scales  rsl
      where  rsl.rating_scale_id = p_rating_scale_id
      and   rsl.rating_scale_id = rsl_tl.rating_scale_id
      and pbg.business_group_id = rsl.business_group_id;

Line: 114

    select pbg.legislation_code
      from per_business_groups     pbg
         , per_rating_scales_tl rsl_tl
         , per_rating_scales  rsl
     where
       rsl.rating_scale_id       = p_rating_scale_id
       and rsl_tl.language          = p_language
       and pbg.business_group_id = rsl.business_group_id
       and rsl.rating_scale_id   = rsl_tl.rating_scale_id;

Line: 209

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

Line: 231

End chk_non_updateable_args;

Line: 283

     select rsc.business_group_id
     from per_rating_scales    rsc
        , per_rating_scales_tl rsl
     where rsc.rating_scale_id = rsl.rating_scale_id
     and   rsl.language        = p_language
     and   (   (p_rating_scale_id is null)
              or(rsc.rating_scale_id <> p_rating_scale_id)
            )
     and rsl.name = p_name
     and p_business_group_id is null
     UNION
     select rsc.business_group_id
     from per_rating_scales    rsc
        , per_rating_scales_tl rsl
     where rsc.rating_scale_id = rsl.rating_scale_id
     and   rsl.language        = p_language
     and   (  (p_rating_scale_id is null)
	     or(rsc.rating_scale_id <> p_rating_scale_id)
           )
     and    rsl.name = p_name
     and    (rsc.business_group_id = p_business_group_id or
	     rsc.business_group_id is null)
     and    p_business_group_id is not null;

Line: 371

    select rsc.business_group_id
      from per_rating_scales rsc
     where rsc.rating_scale_id = nvl(p_rec.rating_scale_id, p_rating_scale_id);

Line: 399

Procedure insert_validate
  (p_rec                          in per_rsl_shd.g_rec_type
  ,p_rating_scale_id              in per_rating_scales_tl.rating_scale_id%TYPE
  ) is
--
-- Name : M. Burton
-- Date  02-DEC-2002
-- Description Amended with comment
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 424

End insert_validate;

Line: 429

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

Line: 447

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 457

End update_validate;

Line: 462

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

Line: 474

End delete_validate;