eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPP_UPD dependencies on PER_SPINAL_POINT_STEPS_F

Line 423: l_step_end_date per_spinal_point_steps_f.effective_end_date%type; -- added for 7457065

419: ) is
420: --
421: l_proc varchar2(72) := g_package||'post_update';
422: -- code changes start for bug 7457065
423: l_step_end_date per_spinal_point_steps_f.effective_end_date%type; -- added for 7457065
424: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type; -- added for 7457065
425:
426: cursor c_step_end_date is
427: select max(effective_end_date)

Line 424: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type; -- added for 7457065

420: --
421: l_proc varchar2(72) := g_package||'post_update';
422: -- code changes start for bug 7457065
423: l_step_end_date per_spinal_point_steps_f.effective_end_date%type; -- added for 7457065
424: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type; -- added for 7457065
425:
426: cursor c_step_end_date is
427: select max(effective_end_date)
428: from per_spinal_point_steps_f

Line 428: from per_spinal_point_steps_f

424: l_next_placement_st_date per_spinal_point_steps_f.effective_start_date%type; -- added for 7457065
425:
426: cursor c_step_end_date is
427: select max(effective_end_date)
428: from per_spinal_point_steps_f
429: where step_id = p_rec.step_id;
430:
431: cursor c_next_placement_st_date is
432: select min(effective_start_date)