APPS.HR_GRADE_SCALE_API dependencies on PER_SPINAL_POINT_STEPS_F

Line 76: -- Declare for per_spinal_point_steps_f

72: l_effective_start_date date;
73: l_effective_end_date date;
74:
75: --
76: -- Declare for per_spinal_point_steps_f
77: l_sequence per_spinal_points.sequence%TYPE;
78: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
79: --
80: cursor csr_get_sequence is

Line 78: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

74:
75: --
76: -- Declare for per_spinal_point_steps_f
77: l_sequence per_spinal_points.sequence%TYPE;
78: lv_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
79: --
80: cursor csr_get_sequence is
81: select psp.sequence
82: from per_spinal_points psp

Line 509: from per_spinal_point_steps_f sps

505: l_proc varchar2(72) := g_package||'delete_child_grade_steps';
506: --
507: cursor csr_chk_placements(p_date date) is
508: select 'x'
509: from per_spinal_point_steps_f sps
510: where sps.grade_spine_id = p_grade_spine_id
511: and exists (select null
512: from per_spinal_point_placements_f spp
513: where spp.step_id = sps.step_id

Line 518: from per_spinal_point_steps_f sps

514: and p_date < spp.effective_end_date);
515: --
516: cursor csr_chk_assignments(p_date date) is
517: select 'x'
518: from per_spinal_point_steps_f sps
519: where sps.grade_spine_id = p_grade_spine_id
520: and exists (select null
521: from per_assignments_f a
522: where a.special_ceiling_step_id = sps.step_id

Line 528: from per_spinal_point_steps_f sps

524: and p_date < a.effective_end_date);
525: --
526: cursor csr_chk_positions(p_date date) is
527: select 'x'
528: from per_spinal_point_steps_f sps
529: where sps.grade_spine_id = p_grade_spine_id
530: and exists (select null
531: from hr_all_positions_f p
532: where p.entry_step_id = sps.step_id

Line 539: from per_spinal_point_steps_f

535: Cursor csr_grade_steps IS
536: select distinct step_id
537: ,min(effective_start_date) min_eff_start_date
538: ,max(effective_end_date) max_eff_end_date
539: from per_spinal_point_steps_f
540: where grade_spine_id = p_grade_spine_id
541: group by step_id;
542: --
543: Cursor csr_step_details(p_step_id number,p_eff_date date) IS

Line 545: from per_spinal_point_steps_f

541: group by step_id;
542: --
543: Cursor csr_step_details(p_step_id number,p_eff_date date) IS
544: select object_version_number
545: from per_spinal_point_steps_f
546: where step_id = p_step_id
547: and p_eff_date between effective_start_date and effective_end_date;
548: --
549: Cursor csr_grade_spine_esd IS

Line 554: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;

550: select min(effective_start_date)
551: from per_grade_spines_f
552: where grade_spine_id = p_grade_spine_id;
553: --
554: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
555: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
556: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
557: l_min_eff_start_date date;
558: l_max_eff_end_date date;

Line 555: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;

551: from per_grade_spines_f
552: where grade_spine_id = p_grade_spine_id;
553: --
554: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
555: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
556: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
557: l_min_eff_start_date date;
558: l_max_eff_end_date date;
559: l_date date;

Line 556: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;

552: where grade_spine_id = p_grade_spine_id;
553: --
554: l_object_version_number per_spinal_point_steps_f.object_version_number%TYPE;
555: l_effective_start_date per_spinal_point_steps_f.effective_start_date%TYPE;
556: l_effective_end_date per_spinal_point_steps_f.effective_end_date%TYPE;
557: l_min_eff_start_date date;
558: l_max_eff_end_date date;
559: l_date date;
560: l_effective_date date;