APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_SPINAL_POINT_STEPS_F

Line 169: per_spinal_point_steps_f sps

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

Line 237: per_spinal_point_steps_f sps,

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

Line 254: from per_spinal_point_steps_f sps2

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

Line 273: per_spinal_point_steps_f sps,

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