APPS.PER_GRADE_SPINES_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 221: from per_spinal_point_placements_f sp

217: and gs.parent_spine_id = p_pspine_id
218: and gs.grade_id = p_grd_id
219: and exists
220: (select null
221: from per_spinal_point_placements_f sp
222: where sp.step_id = sps.step_id);
223: --
224: cursor c2 is
225: select 'x'

Line 505: per_spinal_point_placements_f p,

501: from sys.dual
502: where exists
503: (select null
504: from per_all_assignments_f a,
505: per_spinal_point_placements_f p,
506: per_spinal_point_steps_f s
507: where a.assignment_id = p.assignment_id
508: and a.effective_start_date <= p_val_start
509: and a.effective_end_date >= p_val_end

Line 558: delete from per_spinal_point_placements_f

554: begin
555: --
556: hr_utility.set_location('per_grade_spines_pkg.zap_placement',1);
557: --
558: delete from per_spinal_point_placements_f
559: where placement_id = p_placement_id
560: and step_id = p_step_id
561: and effective_start_date = p_eff_start_date;
562: --

Line 580: update per_spinal_point_placements_f

576: begin
577: --
578: hr_utility.set_location('per_grade_spines_pkg.update_placement',1);
579: --
580: update per_spinal_point_placements_f
581: set effective_end_date = p_newdate
582: where placement_id = p_placement_id
583: and step_id = p_step_id
584: and effective_start_date = p_eff_start_date;

Line 715: from per_spinal_point_placements_f

711: cursor get_plcmnts(p_step_id in number) is
712: select placement_id,
713: effective_start_date,
714: effective_end_date
715: from per_spinal_point_placements_f
716: where step_id = p_step_id;
717: --
718: --
719: begin

Line 803: l_plcmnt_id per_spinal_point_placements_f.placement_id%TYPE;

799: p_grade_id in number,
800: p_eff_end_date in date) is
801: l_step_id per_spinal_point_steps_f.step_id%TYPE;
802: l_stp_eff_start per_spinal_point_steps_f.effective_start_date%TYPE;
803: l_plcmnt_id per_spinal_point_placements_f.placement_id%TYPE;
804: l_plc_eff_start per_spinal_point_placements_f.effective_start_date%TYPE;
805: l_gspine_opento_date date;
806: l_stp_opento_date date;
807: l_plc_opento_date date;

Line 804: l_plc_eff_start per_spinal_point_placements_f.effective_start_date%TYPE;

800: p_eff_end_date in date) is
801: l_step_id per_spinal_point_steps_f.step_id%TYPE;
802: l_stp_eff_start per_spinal_point_steps_f.effective_start_date%TYPE;
803: l_plcmnt_id per_spinal_point_placements_f.placement_id%TYPE;
804: l_plc_eff_start per_spinal_point_placements_f.effective_start_date%TYPE;
805: l_gspine_opento_date date;
806: l_stp_opento_date date;
807: l_plc_opento_date date;
808: l_eot date := to_date('31-12-4712','DD-MM-YYYY');

Line 838: from per_spinal_point_placements_f

834: --
835: cursor get_placements(p_step_id in number) is
836: select placement_id,
837: effective_start_date
838: from per_spinal_point_placements_f
839: where step_id = p_step_id
840: and effective_end_date = p_eff_end_date;
841: --
842: -- cursor to determine the date to extend the placement records to if

Line 849: from per_spinal_point_placements_f p,

845: cursor get_plcdate(p_plc_id in number,
846: p_grd_id in number,
847: p_plc_start in date) is
848: select a.effective_start_date -1
849: from per_spinal_point_placements_f p,
850: per_all_assignments_f a
851: where p.placement_id = p_plc_id
852: and p.effective_start_date = p_plc_start
853: and a.assignment_id = p.assignment_id

Line 862: from per_spinal_point_placements_f p,

858: -- and reopening of the placement.
859: --
860: cursor get_assend(p_plc_id in number) is
861: select max(a.effective_end_date)
862: from per_spinal_point_placements_f p,
863: per_all_assignments_f a
864: where p.placement_id = p_plc_id
865: and p.assignment_id = a.assignment_id;
866: --