[Home] [Help]
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));
298:
921: -- ------------------------------------------------------------------
922: BEGIN
923: select pgs.ceiling_step_id, nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
924: into l_max_ceiling_step_id,l_special_ceiling_step_id
925: from per_grade_spines_f pgs,
926: per_all_assignments_f paa
927: where paa.assignment_id = p_assignment_id
928: and pgs.parent_spine_id = p_parent_spine_id
929: and pgs.grade_spine_id = p_grade_spine_id
1410: l_datetrack_mode varchar2(30) := 'UPDATE_CHANGE_INSERT';
1411: l_reason varchar2(30) := 'AI';
1412: LC_Object_Version_Number per_spinal_point_placements_f.object_version_number%TYPE;
1413: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1414: l_grade_spine_id per_grade_spines_f.grade_spine_id%TYPE;
1415: l_update varchar2(2);
1416: l_update2 varchar2(2);
1417: l_exception_report1 varchar2(2);
1418: l_exception_report2 varchar2(2);
1475: spp.effective_start_date,
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,
1582: spp.effective_end_date,
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,