APPS.HR_TEMPLATE_CANVASES_API dependencies on HR_TEMPLATE_WINDOWS_B

Line 42: ,hr_template_windows_b htw

38: CURSOR cur_api_val
39: IS
40: SELECT source_form_template_id
41: FROM hr_source_form_templates hsf
42: ,hr_template_windows_b htw
43: WHERE hsf.form_template_id_to = htw.form_template_id
44: AND htw.template_window_id = p_template_window_id;
45:
46: l_template_tab_page_id_to number;

Line 282: ,hr_template_windows_b htw

278: CURSOR cur_api_val
279: IS
280: SELECT source_form_template_id
281: FROM hr_source_form_templates hsf
282: ,hr_template_windows_b htw
283: WHERE hsf.form_template_id_to = htw.form_template_id
284: AND htw.template_window_id = p_template_window_id;
285:
286: l_canvas_property_id number;

Line 569: ,hr_template_windows_b htw

565: IS
566: SELECT source_form_template_id
567: FROM hr_source_form_templates hsf
568: ,hr_template_canvases_b htc
569: ,hr_template_windows_b htw
570: WHERE hsf.form_template_id_to = htw.form_template_id
571: AND htw.template_window_id = htc.template_window_id
572: AND htc.template_canvas_id = p_template_canvas_id;
573:

Line 754: ,hr_template_windows_b htw

750: IS
751: SELECT source_form_template_id
752: FROM hr_source_form_templates hsf
753: ,hr_template_canvases_b htc
754: ,hr_template_windows_b htw
755: WHERE hsf.form_template_id_to = htw.form_template_id
756: AND htw.template_window_id = htc.template_window_id
757: AND htc.template_canvas_id = p_template_canvas_id;
758: