DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B

Line 80: ,hr_template_item_contexts_b tic

76: SELECT itptl.default_value
77: FROM hr_item_contexts icx
78: ,hr_item_properties_b itpb
79: ,hr_item_properties_tl itptl
80: ,hr_template_item_contexts_b tic
81: WHERE icx.segment1 = p_emp_apl_flag
82: AND icx.item_context_id = tic.item_context_id
83: AND tic.context_type = 'QH_PER_TYPE'
84: AND tic.template_item_id = p_template_item_id