APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_SOURCE_FORM_TEMPLATES

Line 43: FROM hr_source_form_templates hsf

39: CURSOR cur_api_val
40: IS
41: SELECT 1 from dual where exists( --added line for 2832106
42: SELECT source_form_template_id
43: FROM hr_source_form_templates hsf
44: WHERE hsf.form_template_id_to = p_form_template_id);
45:
46: l_template_canvas_id_to number;
47: l_ovn_canvas number;

Line 264: FROM hr_source_form_templates hsf

260: CURSOR cur_api_val
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);

Line 581: FROM hr_source_form_templates hsf

577: CURSOR cur_api_val
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:

Line 784: FROM hr_source_form_templates hsf

780: CURSOR cur_api_val
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