APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_SPINAL_POINT_STEPS_F

Line 167: per_spinal_point_steps_f sps

163: cursor csr_sequence_number is
164: select sps.sequence,spp1.parent_spine_id
165: from per_spinal_point_placements_f spp1,
166: per_spinal_point_placements_f spp2,
167: per_spinal_point_steps_f sps
168: where spp1.step_id = sps.step_id
169: and p_effective_date = spp1.effective_start_date
170: and spp2.effective_start_date = spp1.effective_end_date +1
171: and spp2.placement_id = spp1.placement_id

Line 235: per_spinal_point_steps_f sps,

231: hr_utility.set_location('grade name',122);
232: select substr(pg.name,1,30),pgs.grade_spine_id
233: into l_grade_name,l_grade_spine_id
234: from per_grades_vl pg,
235: per_spinal_point_steps_f sps,
236: per_grade_spines_f pgs
237: where pg.grade_id = pgs.grade_id
238: and pgs.grade_spine_id = sps.grade_spine_id
239: and sps.step_id = p_step_id

Line 252: from per_spinal_point_steps_f sps2

248: --
249: hr_utility.set_location('max step_id for the pay scale',123);
250: select max(sps2.sequence)
251: into l_step_id
252: from per_spinal_point_steps_f sps2
253: where sps2.grade_spine_id = p_grade_spine_id
254: and p_effective_date between sps2.effective_start_date
255: and sps2.effective_end_date;
256:

Line 271: per_spinal_point_steps_f sps,

267: select distinct pgs.ceiling_step_id,
268: nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
269: into l_ceiling_step_id, l_special_ceiling_step_id
270: from per_grade_spines_f pgs,
271: per_spinal_point_steps_f sps,
272: per_spinal_point_placements_f spp,
273: per_all_assignments_f paa
274: where pgs.grade_spine_id = sps.grade_spine_id
275: and paa.assignment_id = spp.assignment_id