APPS.PER_PSP_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , per_spinal_points psp
     where psp.spinal_point_id = p_spinal_point_id
       and pbg.business_group_id = psp.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , per_spinal_points psp
     where psp.spinal_point_id = p_spinal_point_id
       and pbg.business_group_id = psp.business_group_id;

Line: 278

     select null
     from   per_parent_spines pps
     where  pps.business_group_id = p_business_group_id
     and    pps.parent_spine_id = p_parent_spine_id;

Line: 366

	select 'x'
	from per_spinal_points
	where sequence = p_sequence
        and parent_spine_id = p_parent_spine_id
        and spinal_point = p_spinal_point;

Line: 455

	select 'x'
	from per_spinal_points
	where spinal_point = p_spinal_point
        and parent_spine_id = p_parent_spine_id;

Line: 528

PROCEDURE chk_delete(
   p_spinal_point_id         in per_spinal_points.spinal_point_id%TYPE
  ,p_parent_spine_id         in per_spinal_points.parent_spine_id%TYPE
 ) is
  --
  l_proc         varchar2(72) := g_package||'chk_delete';

Line: 537

	select 'x'
	from  per_spinal_point_steps_f sps
             ,per_grade_spines_f       pgs
	where sps.grade_spine_id = pgs.grade_spine_id
	and   pgs.parent_spine_id = p_parent_spine_id
	and   sps.spinal_point_id = p_spinal_point_id;

Line: 545

	select 'x'
	from pay_grade_rules_f
	where grade_or_spinal_point_id = p_spinal_point_id
	and rate_type = 'SP';

Line: 596

end chk_delete;

Line: 805

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in per_psp_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 848

End chk_non_updateable_args;

Line: 853

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

Line: 933

End insert_validate;

Line: 938

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

Line: 975

  chk_non_updateable_args
    (p_effective_date   => p_effective_date
    ,p_rec              => p_rec
    );

Line: 1026

End update_validate;

Line: 1031

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

Line: 1043

  chk_delete(p_spinal_point_id  => p_rec.spinal_point_id
            ,p_parent_spine_id  => p_rec.parent_spine_id);

Line: 1047

End delete_validate;