368: and template_window_id = x_template_window_id;
369:
370: select form_tab_page_id
371: into x_form_tab_page_id
372: from hr_form_tab_pages_b
373: where tab_page_name = x_form_tab_page_name
374: and form_canvas_id = x_form_canvas_id;
375:
376: select template_tab_page_id
398: hr_form_templates_b hft,
399: hr_template_windows_b htw,
400: hr_form_canvases_b hfc,
401: hr_template_canvases_b htc,
402: hr_form_tab_pages_b hftp,
403: hr_template_tab_pages_b htpb
404: where hfw.window_name = x_window_name
405: and hfw.application_id = x_application_id
406: and hfw.form_id = x_form_id