DBA Data[Home] [Help]

APPS.HR_TCN_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

    select
       template_canvas_id
      ,object_version_number
      ,template_window_id
      ,form_canvas_id
    from	hr_template_canvases_b
    where	template_canvas_id = p_template_canvas_id;
Line: 135

    select
       template_canvas_id
      ,object_version_number
      ,template_window_id
      ,form_canvas_id
    from	hr_template_canvases_b
    where	template_canvas_id = p_template_canvas_id
    for	update nowait;