480: IF ltrim(rtrim(x_tab_page_name_1)) IS NOT NULL THEN
481:
482: select form_tab_page_id
483: into x_form_tab_page_id
484: from hr_form_tab_pages_b
485: where form_canvas_id = x_form_canvas_id
486: and tab_page_name = x_tab_page_name_1;
487:
488: ELSE
494: IF ltrim(rtrim(x_tab_page_name_2)) IS NOT NULL THEN
495:
496: select form_tab_page_id
497: into x_form_tab_page_id_override
498: from hr_form_tab_pages_b
499: where form_canvas_id = x_form_canvas_id
500: and tab_page_name = x_tab_page_name_2;
501:
502: ELSE