APPS.PQH_GSP_DEFAULT dependencies on PER_SPINAL_POINT_STEPS_F

Line 227: from per_spinal_point_steps_f

223: p_grade_spine_id out nocopy number) is
224: begin
225: select sequence,grade_spine_id
226: into p_step_seq,p_grade_spine_id
227: from per_spinal_point_steps_f
228: where p_effective_date between effective_start_date and effective_end_date
229: and step_id = p_step_id;
230: hr_utility.set_location('step seq # is '||p_step_seq,10);
231: exception

Line 255: From Per_Spinal_Point_steps_F a

251: l_Incr Number := 1;
252:
253: Cursor Step(P_Grade_Spine_Id in Number, P_Seq In Number) is
254: Select Sequence, Step_Id
255: From Per_Spinal_Point_steps_F a
256: Where Grade_Spine_id = P_Grade_Spine_id
257: and P_Effective_Date Between Effective_Start_Date and effective_End_Date
258: and Sequence > P_Seq
259: Order By Sequence asc;

Line 330: from per_spinal_point_steps_f

326: /* if p_steps_left is null then
327: begin
328: select step_id
329: into p_next_step_id
330: from per_spinal_point_steps_f
331: where p_effective_date between effective_start_date and effective_end_date
332: and grade_spine_id = l_grade_spine_id
333: and sequence = l_dest_step_seq;
334: exception

Line 598: from per_spinal_point_steps_f

594: l_next_seq number;
595: l_next_step_id number;
596: cursor csr_steps is
597: select step_id,sequence
598: from per_spinal_point_steps_f
599: where grade_spine_id = l_grade_spine_id
600: and p_effective_date between effective_start_date and effective_end_date
601: and sequence > l_seq
602: order by sequence;