DBA Data[Home] [Help]

APPS.HR_TIC_BUS dependencies on HR_ITEM_CONTEXTS

Line 289: ,hr_item_contexts icx

285: SELECT ifs.id_flex_structure_code
286: ,icx.segment1
287: ,icx.segment2
288: FROM fnd_id_flex_structures ifs
289: ,hr_item_contexts icx
290: WHERE ifs.application_id = 800
291: AND ifs.id_flex_code = 'ICX'
292: AND ifs.id_flex_num = icx.id_flex_num
293: AND icx.item_context_id = p_item_context_id;

Line 305: ,hr_item_contexts icx

301: SELECT ifs.id_flex_structure_code
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