DBA Data[Home] [Help]

APPS.HR_FORM_STACK_CANVAS_INFO SQL Statements

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

Line: 26

    SELECT fsc.form_tab_stacked_canvas_id form_stack_canvas_id
          ,fc1.canvas_name
          ,ftp.tab_page_name
          ,fc2.canvas_name stack_canvas_name
      FROM hr_form_canvases_b fc2
          ,hr_form_tab_stacked_canvases fsc
          ,hr_form_tab_pages_b ftp
          ,hr_form_canvases_b fc1
          ,hr_form_windows_b fwn
     WHERE fc2.form_canvas_id = fsc.form_canvas_id
       AND fsc.form_tab_page_id = ftp.form_tab_page_id
       AND ftp.form_canvas_id = fc1.form_canvas_id
       AND fc1.form_window_id = fwn.form_window_id
       AND fwn.application_id = p_application_id
       AND fwn.form_id = p_form_id;