APPS.HR_TCP_BUS dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B

Line 53: ,hr_template_item_contexts_b tic

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
57: and tic.template_item_context_id = tcp.template_item_context_id

Line 253: ,hr_template_item_contexts_b tic

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: --
257: cursor csr_template_tab_page is

Line 273: ,hr_template_item_contexts_b tic

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
277: and fs1.form_tab_page_id = fim.form_tab_page_id