[Home] [Help]
126: Cursor csr_old_spinal_point is
127: select substr(psp1.spinal_point,1,20)
128: from per_spinal_point_placements_f spp1,
129: per_spinal_point_placements_f spp,
130: per_spinal_points psp1,
131: per_spinal_point_steps_f sps1,
132: per_spinal_point_steps_f sps2
133: --pay_grade_rules_f pgr2
134: where spp1.step_id <> p_step_id -- 343
175: Cursor csr_old_spinal_value is
176: select pgr2.value
177: from per_spinal_point_placements_f spp1,
178: per_spinal_point_placements_f spp,
179: per_spinal_points psp1,
180: per_spinal_point_steps_f sps1,
181: pay_grade_rules_f pgr2,
182: per_spinal_point_steps_f sps2
183: where p_step_id <> spp1.step_id
279: Cursor csr_increment4 is
280: select spp.placement_id
281: from per_spinal_point_placements_f spp,
282: per_spinal_point_steps_f sps,
283: per_spinal_points psp
284: where spp.placement_id = p_placement_id
285: and spp.effective_start_date = p_effective_start_date
286: and spp.step_id = p_step_id
287: and sps.step_id = spp.step_id
286: and spp.step_id = p_step_id
287: and sps.step_id = spp.step_id
288: and sps.spinal_point_id = psp.spinal_point_id
289: and psp.spinal_point_id = (select psp1.spinal_point_id
290: from per_spinal_points psp1
291: where psp1.parent_spine_id = spp.parent_spine_id
292: and psp1.sequence = (select min(sequence)
293: from per_spinal_points psp2,
294: per_grade_spines_f pgs
289: and psp.spinal_point_id = (select psp1.spinal_point_id
290: from per_spinal_points psp1
291: where psp1.parent_spine_id = spp.parent_spine_id
292: and psp1.sequence = (select min(sequence)
293: from per_spinal_points psp2,
294: per_grade_spines_f pgs
295: where psp2.parent_spine_id = pgs.parent_spine_id
296: and pgs.grade_spine_id = p_grade_spine_id
297: and psp2.parent_spine_id = psp1.parent_spine_id));
1042: into l_max_sequence_number,
1043: l_max_special_sequence_number,
1044: l_max_spinal_point_id,
1045: l_max_special_spinal_point_id
1046: from per_spinal_points psp1,
1047: per_spinal_points psp2,
1048: per_spinal_point_steps_f sps1,
1049: per_spinal_point_steps_f sps2
1050: where psp1.spinal_point_id = sps1.spinal_point_id
1043: l_max_special_sequence_number,
1044: l_max_spinal_point_id,
1045: l_max_special_spinal_point_id
1046: from per_spinal_points psp1,
1047: per_spinal_points psp2,
1048: per_spinal_point_steps_f sps1,
1049: per_spinal_point_steps_f sps2
1050: where psp1.spinal_point_id = sps1.spinal_point_id
1051: and psp2.spinal_point_id = sps2.spinal_point_id
1476: spp.effective_end_date,
1477: pgs.grade_spine_id
1478: FROM per_all_assignments_f asg,
1479: per_grade_spines_f pgs,
1480: per_spinal_points psp1,
1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1478: FROM per_all_assignments_f asg,
1479: per_grade_spines_f pgs,
1480: per_spinal_points psp1,
1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1485: per_periods_of_service pps --12727056
1486: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1583: pgs.grade_spine_id
1584: FROM per_all_assignments_f asg,
1585: pay_people_groups ppg,
1586: per_grade_spines_f pgs,
1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,
1589: per_spinal_points psp,
1590: per_spinal_point_steps_f sps,
1591: per_spinal_point_placements_f spp
1585: pay_people_groups ppg,
1586: per_grade_spines_f pgs,
1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,
1589: per_spinal_points psp,
1590: per_spinal_point_steps_f sps,
1591: per_spinal_point_placements_f spp
1592: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1593: OR