DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API dependencies on HR_TEMPLATE_ITEMS_B

Line 31: ,hr_template_items_b hti

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

Line 206: ,hr_template_items_b hti

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;