564: CURSOR cur_api_val
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;
749: CURSOR cur_api_val
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;