DBA Data[Home] [Help]

APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_TEMPLATE_CANVASES_B

Line 266: -- ,hr_template_canvases_b htc

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:
270: CURSOR csr_form_canvases

Line 562: FROM hr_template_canvases_b tcn

558: CURSOR csr_template_canvases
559: IS
560: SELECT tcn.template_canvas_id
561: ,tcn.object_version_number
562: FROM hr_template_canvases_b tcn
563: ,hr_form_canvases_b fcn
564: WHERE tcn.template_window_id = p_template_window_id
565: AND tcn.form_canvas_id = fcn.form_canvas_id
566: AND fcn.canvas_type = 'CONTENT';

Line 786: -- ,hr_template_canvases_b htc

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);
790: