273:
274:
275: select hti.template_item_id
276: into x_template_item_id
277: from hr_form_templates_b hft
278: ,hr_template_items_b hti
279: where hti.form_item_id = x_form_item_id
280: and hti.form_template_id = hft.form_template_id
281: and hft.form_id = x_form_id
341: and form_id = x_form_id;
342:
343: select form_template_id
344: into x_form_template_id
345: from hr_form_templates_b
346: where ( (legislation_code is null and x_territory_short_name is null)
347: or (legislation_code = x_territory_short_name) )
348: and template_name = x_template_name
349: and application_id = x_application_id
394: x_template_canvas_id,
395: x_form_tab_page_id,
396: x_template_tab_page_id
397: from hr_form_windows_b hfw,
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,