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