APPS.PER_SPP_DEL dependencies on PER_SPINAL_POINT_STEPS_F

Line 303: l_step_end_date per_spinal_point_steps_f.effective_end_date%type;

299: --
300: l_proc varchar2(72) := g_package||'post_delete';
301:
302: -- changes start for 7457065
303: l_step_end_date per_spinal_point_steps_f.effective_end_date%type;
304: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type;
305: --
306: cursor c_step_end_date is
307: select max(effective_end_date)

Line 304: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type;

300: l_proc varchar2(72) := g_package||'post_delete';
301:
302: -- changes start for 7457065
303: l_step_end_date per_spinal_point_steps_f.effective_end_date%type;
304: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type;
305: --
306: cursor c_step_end_date is
307: select max(effective_end_date)
308: from per_spinal_point_steps_f

Line 308: from per_spinal_point_steps_f

304: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type;
305: --
306: cursor c_step_end_date is
307: select max(effective_end_date)
308: from per_spinal_point_steps_f
309: where step_id = p_rec.step_id;
310: -- max taken because there may be date track updates to the step
311: -- records in the table per_spinal_point_steps_f
312: --

Line 311: -- records in the table per_spinal_point_steps_f

307: select max(effective_end_date)
308: from per_spinal_point_steps_f
309: where step_id = p_rec.step_id;
310: -- max taken because there may be date track updates to the step
311: -- records in the table per_spinal_point_steps_f
312: --
313: cursor c_next_placement_st_date is
314: select min(effective_start_date)
315: from per_spinal_point_placements_f