DBA Data[Home] [Help]

APPS.HR_TEMPLATE_TAB_PAGES_API dependencies on HR_TEMPLATE_WINDOWS_B

Line 38: ,hr_template_windows_b htw

34: CURSOR cur_api_val
35: IS
36: SELECT source_form_template_id
37: FROM hr_source_form_templates hsf
38: ,hr_template_windows_b htw
39: ,hr_template_canvases_b htc
40: WHERE hsf.form_template_id_to = htw.form_template_id
41: AND htw.template_window_id = htc.template_window_id
42: AND htc.template_canvas_id = p_template_canvas_id;

Line 266: ,hr_template_windows_b htw

262: CURSOR cur_api_val
263: IS
264: SELECT source_form_template_id
265: FROM hr_source_form_templates hsf
266: ,hr_template_windows_b htw
267: ,hr_template_canvases_b htc
268: WHERE hsf.form_template_id_to = htw.form_template_id
269: AND htw.template_window_id = htc.template_window_id
270: AND htc.template_canvas_id = p_template_canvas_id;

Line 568: ,hr_template_windows_b htw

564: CURSOR cur_api_val
565: IS
566: SELECT source_form_template_id
567: FROM hr_source_form_templates hsf
568: ,hr_template_windows_b htw
569: ,hr_template_canvases_b htc
570: ,hr_template_tab_pages_b http
571: WHERE hsf.form_template_id_to = htw.form_template_id
572: AND htw.template_window_id = htc.template_window_id

Line 766: ,hr_template_windows_b htw

762: CURSOR cur_api_val
763: IS
764: SELECT source_form_template_id
765: FROM hr_source_form_templates hsf
766: ,hr_template_windows_b htw
767: ,hr_template_canvases_b htc
768: ,hr_template_tab_pages_b http
769: WHERE hsf.form_template_id_to = htw.form_template_id
770: AND htw.template_window_id = htc.template_window_id