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