APPS.HR_TCP_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_contexts_b tic
54: ,hr_template_item_context_pages tcp
55: where tmp.form_template_id = tim.form_template_id
56: and tim.template_item_id = tic.template_item_id

Line 252: from hr_template_items_b tim

248: ) is
249: --
250: cursor csr_template_item_context is
251: select tim.form_template_id
252: from hr_template_items_b tim
253: ,hr_template_item_contexts_b tic
254: where tim.template_item_id = tic.template_item_id
255: and tic.template_item_context_id = p_template_item_context_id;
256: --

Line 272: ,hr_template_items_b tim

268: from hr_template_tab_pages_b ttp
269: ,hr_form_tab_stacked_canvases fs2
270: ,hr_form_tab_stacked_canvases fs1
271: ,hr_form_items_b fim
272: ,hr_template_items_b tim
273: ,hr_template_item_contexts_b tic
274: where p_template_tab_page_id = ttp.template_tab_page_id
275: and ttp.form_tab_page_id = fs2.form_tab_page_id
276: and fs2.form_canvas_id = fs1.form_canvas_id