APPS.HRSPINE dependencies on PER_SPINAL_POINTS

Line 128: per_spinal_points psp1,

124: Cursor csr_old_spinal_point is
125: select substr(psp1.spinal_point,1,20)
126: from per_spinal_point_placements_f spp1,
127: per_spinal_point_placements_f spp,
128: per_spinal_points psp1,
129: per_spinal_point_steps_f sps1,
130: per_spinal_point_steps_f sps2
131: --pay_grade_rules_f pgr2
132: where spp1.step_id <> p_step_id -- 343

Line 177: per_spinal_points psp1,

173: Cursor csr_old_spinal_value is
174: select pgr2.value
175: from per_spinal_point_placements_f spp1,
176: per_spinal_point_placements_f spp,
177: per_spinal_points psp1,
178: per_spinal_point_steps_f sps1,
179: pay_grade_rules_f pgr2,
180: per_spinal_point_steps_f sps2
181: where p_step_id <> spp1.step_id

Line 281: per_spinal_points psp

277: Cursor csr_increment4 is
278: select spp.placement_id
279: from per_spinal_point_placements_f spp,
280: per_spinal_point_steps_f sps,
281: per_spinal_points psp
282: where spp.placement_id = p_placement_id
283: and spp.effective_start_date = p_effective_start_date
284: and spp.step_id = p_step_id
285: and sps.step_id = spp.step_id

Line 288: from per_spinal_points psp1

284: and spp.step_id = p_step_id
285: and sps.step_id = spp.step_id
286: and sps.spinal_point_id = psp.spinal_point_id
287: and psp.spinal_point_id = (select psp1.spinal_point_id
288: from per_spinal_points psp1
289: where psp1.parent_spine_id = spp.parent_spine_id
290: and psp1.sequence = (select min(sequence)
291: from per_spinal_points psp2,
292: per_grade_spines_f pgs

Line 291: from per_spinal_points psp2,

287: and psp.spinal_point_id = (select psp1.spinal_point_id
288: from per_spinal_points psp1
289: where psp1.parent_spine_id = spp.parent_spine_id
290: and psp1.sequence = (select min(sequence)
291: from per_spinal_points psp2,
292: per_grade_spines_f pgs
293: where psp2.parent_spine_id = pgs.parent_spine_id
294: and pgs.grade_spine_id = p_grade_spine_id
295: and psp2.parent_spine_id = psp1.parent_spine_id));

Line 1044: from per_spinal_points psp1,

1040: into l_max_sequence_number,
1041: l_max_special_sequence_number,
1042: l_max_spinal_point_id,
1043: l_max_special_spinal_point_id
1044: from per_spinal_points psp1,
1045: per_spinal_points psp2,
1046: per_spinal_point_steps_f sps1,
1047: per_spinal_point_steps_f sps2
1048: where psp1.spinal_point_id = sps1.spinal_point_id

Line 1045: per_spinal_points psp2,

1041: l_max_special_sequence_number,
1042: l_max_spinal_point_id,
1043: l_max_special_spinal_point_id
1044: from per_spinal_points psp1,
1045: per_spinal_points psp2,
1046: per_spinal_point_steps_f sps1,
1047: per_spinal_point_steps_f sps2
1048: where psp1.spinal_point_id = sps1.spinal_point_id
1049: and psp2.spinal_point_id = sps2.spinal_point_id

Line 1478: per_spinal_points psp1,

1474: spp.effective_end_date,
1475: pgs.grade_spine_id
1476: FROM per_all_assignments_f asg,
1477: per_grade_spines_f pgs,
1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,
1481: per_spinal_point_steps_f sps,
1482: per_spinal_point_placements_f spp

Line 1480: per_spinal_points psp,

1476: FROM per_all_assignments_f asg,
1477: per_grade_spines_f pgs,
1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,
1481: per_spinal_point_steps_f sps,
1482: per_spinal_point_placements_f spp
1483: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1484: OR

Line 1580: per_spinal_points psp1,

1576: pgs.grade_spine_id
1577: FROM per_all_assignments_f asg,
1578: pay_people_groups ppg,
1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,
1583: per_spinal_point_steps_f sps,
1584: per_spinal_point_placements_f spp

Line 1582: per_spinal_points psp,

1578: pay_people_groups ppg,
1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,
1583: per_spinal_point_steps_f sps,
1584: per_spinal_point_placements_f spp
1585: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1586: OR