DBA Data[Home] [Help]

APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_TEMPLATE_WINDOWS_B

Line 265: -- ,hr_template_windows_b htw

261: IS
262: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
263: SELECT source_form_template_id
264: FROM hr_source_form_templates hsf
265: -- ,hr_template_windows_b htw
266: -- ,hr_template_canvases_b htc
267: -- ,hr_template_tab_pages_b http
268: WHERE hsf.form_template_id_to = p_form_template_id);
269:

Line 582: ,hr_template_windows_b htw

578: IS
579: SELECT 1 from dual where exists( --added line for 2832106
580: SELECT source_form_template_id
581: FROM hr_source_form_templates hsf
582: ,hr_template_windows_b htw
583: WHERE hsf.form_template_id_to = htw.form_template_id
584: AND htw.template_window_id = p_template_window_id);
585:
586: l_proc varchar2(72) := g_package||'delete_template_window';

Line 785: ,hr_template_windows_b htw

781: IS
782: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
783: SELECT source_form_template_id
784: FROM hr_source_form_templates hsf
785: ,hr_template_windows_b htw
786: -- ,hr_template_canvases_b htc
787: -- ,hr_template_tab_pages_b http
788: WHERE hsf.form_template_id_to = htw.form_template_id
789: AND htw.template_window_id = p_template_window_id);