APPS.HR_SPP_EXCEPTION_DATA SQL Statements

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

Line: 136

  ,p_update			varchar2
  ) is

l_pay_scale		  varchar2(30);

Line: 164

select sps.sequence,spp1.parent_spine_id
  from per_spinal_point_placements_f spp1,
       per_spinal_point_placements_f spp2,
       per_spinal_point_steps_f sps
  where spp1.step_id = sps.step_id
  and p_effective_date = spp1.effective_start_date
  and spp2.effective_start_date = spp1.effective_end_date +1
  and spp2.placement_id = spp1.placement_id
  and spp1.placement_id = p_placement_id;

Line: 179

select parent_spine_id
from per_spinal_point_placements_f
where placement_id = p_placement_id
and parent_spine_id = p_parent_spine_id
and p_effective_date between effective_start_date
			 and effective_end_date;

Line: 203

  select distinct substr(pap.full_name,1,60),paa.assignment_number,paa.payroll_id,
         substr(org.name ,1,60)
  into l_full_name,l_assignment_number,l_payroll_id,l_org_name
  from per_all_people_f pap,
       per_all_assignments_f paa,
       hr_all_organization_units org
  where pap.person_id     = paa.person_id
  and   paa.organization_id = org.organization_id
  and   paa.assignment_id = p_assignment_id
  and   p_effective_date between paa.effective_start_date
                             and paa.effective_end_date
  and   p_effective_date between pap.effective_start_date    -- 2276901
                             and pap.effective_end_date;    -- 2276901

Line: 223

  select pps.name
  into l_pay_scale
  from per_parent_spines pps
  where pps.parent_spine_id = p_parent_spine_id;

Line: 232

  select substr(pg.name,1,30),pgs.grade_spine_id
  into l_grade_name,l_grade_spine_id
  from per_grades_vl pg,
       per_spinal_point_steps_f sps,
       per_grade_spines_f pgs
  where pg.grade_id 	    = pgs.grade_id
  and   pgs.grade_spine_id  = sps.grade_spine_id
  and   sps.step_id         = p_step_id
  and   p_effective_date between sps.effective_start_date
			     and sps.effective_end_date
  and   p_effective_date between pgs.effective_start_date	-- 2276901
			     and pgs.effective_end_date		-- 2276901
  and   sps.spinal_point_id = p_spinal_point_id;

Line: 250

  select max(sps2.sequence)
  into l_step_id
  from per_spinal_point_steps_f sps2
  where sps2.grade_spine_id = p_grade_spine_id
  and   p_effective_date between sps2.effective_start_date
			   and sps2.effective_end_date;

Line: 267

  select distinct pgs.ceiling_step_id,
         nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
  into l_ceiling_step_id, l_special_ceiling_step_id
  from per_grade_spines_f pgs,
       per_spinal_point_steps_f sps,
       per_spinal_point_placements_f spp,
       per_all_assignments_f paa
  where pgs.grade_spine_id = sps.grade_spine_id
  and   paa.assignment_id  = spp.assignment_id
  and   spp.assignment_id  = p_assignment_id
  and   sps.step_id	   = spp.step_id
  -- and   spp.step_id	   = nvl(p_new_step_id,p_step_id)
  and   p_effective_start_date between paa.effective_start_date
			           and paa.effective_end_date
  and   p_effective_start_date between pgs.effective_start_date
                                   and pgs.effective_end_date
  and   p_effective_start_date between sps.effective_start_date
                                   and sps.effective_end_date
  and   p_effective_start_date between spp.effective_start_date
                                   and spp.effective_end_date;

Line: 318

       hr_utility.set_location('Insert done but flagged as future change',127);

Line: 388

       hr_utility.set_location('No insert done as future change',128);

Line: 394

      if p_update = 'Y' then
        l_lookup_code := 'EXC_INC_2';

Line: 404

      if p_update = 'Y' then
        l_lookup_code := 'EXC_INC_3';

Line: 414

       if p_update = 'Y' then
        l_lookup_code := 'EXC_INC_4';