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:
35: CURSOR csr_template_item_contexts
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
210: AND htit.template_item_tab_page_id = p_template_item_tab_page_id;