DBA Data[Home] [Help]

APPS.HR_TIC_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: where tmp.form_template_id = tim.form_template_id
55: and tim.template_item_id = tic.template_item_id
56: and tic.template_item_context_id = p_template_item_context_id;
57: --

Line 306: ,hr_template_item_contexts_b tic

302: ,icx.segment1
303: ,icx.segment2
304: FROM fnd_id_flex_structures ifs
305: ,hr_item_contexts icx
306: ,hr_template_item_contexts_b tic
307: WHERE ifs.application_id = 800
308: AND ifs.id_flex_code = 'ICX'
309: AND ifs.id_flex_num = icx.id_flex_num
310: AND icx.item_context_id = tic.item_context_id