APPS.HR_TIP_BUS dependencies on HR_TEMPLATE_ITEMS_B

Line 52: ,hr_template_items_b tim

48: --
49: cursor csr_leg_code is
50: select tmp.legislation_code
51: from hr_form_templates_b tmp
52: ,hr_template_items_b tim
53: ,hr_template_item_tab_pages tip
54: where tmp.form_template_id = tim.form_template_id
55: and tim.template_item_id = tip.template_item_id
56: and tip.template_item_tab_page_id = p_template_item_tab_page_id;

Line 250: from hr_template_items_b tim

246: ) is
247: --
248: cursor csr_template_item is
249: select tim.form_template_id
250: from hr_template_items_b tim
251: where tim.template_item_id = p_template_item_id;
252: --
253: cursor csr_template_tab_page is
254: select twn.form_template_id

Line 268: ,hr_template_items_b tim

264: from hr_template_tab_pages_b ttp
265: ,hr_form_tab_stacked_canvases fs2
266: ,hr_form_tab_stacked_canvases fs1
267: ,hr_form_items_b fim
268: ,hr_template_items_b tim
269: where p_template_tab_page_id = ttp.template_tab_page_id
270: and ttp.form_tab_page_id = fs2.form_tab_page_id
271: and fs2.form_canvas_id = fs1.form_canvas_id
272: and fs1.form_tab_page_id = fim.form_tab_page_id