26:
27: CURSOR cur_api_val
28: IS
29: SELECT source_form_template_id
30: FROM hr_source_form_templates hsf
31: ,hr_template_items_b hti
32: WHERE hsf.form_template_id_to = hti.form_template_id
33: AND hti.template_item_id = p_template_item_id;
34:
201:
202: CURSOR cur_api_val
203: IS
204: SELECT source_form_template_id
205: FROM hr_source_form_templates hsf
206: ,hr_template_items_b hti
207: ,hr_template_item_tab_pages htit
208: WHERE hsf.form_template_id_to = hti.form_template_id
209: AND hti.template_item_id = htit.template_item_id