APPS.PER_RTL_BUS SQL Statements

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

Line: 13

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

Line: 67

end chk_non_updateable_args;

Line: 119

	select  business_group_id
	from	per_rating_scales
	where   rating_scale_id = p_rating_scale_id;

Line: 128

	select  business_group_id
	from	per_competences
	where   competence_id	= p_competence_id;

Line: 251

	  select 'Y'
	  from   per_rating_levels
	  where  (   (p_rating_level_id is null)
		   or(p_rating_level_id <> rating_level_id)
		 )
	  and	 name = p_name
	  and    (  (nvl(competence_id,hr_api.g_number)
			= nvl(p_competence_id,hr_api.g_number) )
		  and(nvl(rating_scale_id,hr_api.g_number)
			= nvl(p_rating_scale_id,hr_api.g_number))
		 );

Line: 348

	  select 'Y'
	  from   per_rating_levels
	  where  (   (p_rating_level_id is null)
		   or(p_rating_level_id <> rating_level_id)
		 )
	  and	 step_value = p_step_value
	  and    (  (competence_id   = p_competence_id)
		  or(rating_scale_id = p_rating_scale_id)
		 );

Line: 447

  select null
  from	 per_competences cpn
  where  cpn.competence_id = p_competence_id
  and    cpn.rating_scale_id is not null;

Line: 458

  select null
  from   per_rating_levels rtl, per_competences cp,
	 per_competence_elements ce
  where  rtl.competence_id    = p_competence_id
  and    rtl.competence_id    = cp.competence_id
  and    cp.competence_id     = ce.competence_id
  and    ce.type in ('ASSESSMENT_COMPETENCE','REQUIREMENT',
                     'PERSONAL');

Line: 471

  select null
  from   per_rating_levels rtl,
         per_rating_scales rsc,
         per_competences cp
  where  rtl.rating_scale_id 		= p_rating_scale_id
  and    rtl.rating_scale_id 		= rsc.rating_scale_id
  and    rsc.rating_scale_id		= cp.rating_scale_id ;

Line: 483

  select null
  from   per_rating_levels rtl,
         per_rating_scales rsc,
         per_assessment_types aty
  where  rtl.rating_scale_id 		= p_rating_scale_id
  and    rtl.rating_scale_id		= rsc.rating_scale_id
  and    (  (rsc.rating_scale_id	= aty.rating_scale_id)
          or(rsc.rating_scale_id	= aty.weighting_scale_id)
         );

Line: 604

  l_sql_stmt := 'select null
               from per_rating_levels rtl,per_competence_elements perce
               where rtl.rating_level_id = '||p_rating_level_id||
               ' and rtl.rating_level_id = ';

Line: 805

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

Line: 891

End insert_validate;

Line: 896

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

Line: 912

  chk_non_updateable_args(p_rec	=> p_rec);

Line: 937

End update_validate;

Line: 942

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

Line: 966

End delete_validate;

Line: 979

          select legislation_code
          from   per_business_groups pbg,
                 per_rating_levels   prl
          where  prl.rating_level_id   = p_rating_level_id
            and  pbg.business_group_id = prl.business_group_id;

Line: 992

  select 'Y' into l_business_group_flag
  from per_rating_levels
  where rating_level_id = p_rating_level_id
    and business_group_id is null;