DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_ITEM_CONTEXTS

Line 1720: ,hr_item_contexts hic

1716:
1717: select template_item_context_id
1718: into x_template_item_context_id
1719: from hr_template_item_contexts_b ticb
1720: ,hr_item_contexts hic
1721: ,fnd_id_flex_structures fifs
1722: where ticb.template_item_id = x_template_item_id
1723: and ticb.item_context_id = hic.item_context_id
1724: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

Line 2242: ,hr_item_contexts hic

2238: -- segments can be null need this check
2239: select template_item_context_id
2240: into x_template_item_context_id
2241: from hr_template_item_contexts_b ticb
2242: ,hr_item_contexts hic
2243: ,fnd_id_flex_structures fifs
2244: where ticb.template_item_id = x_template_item_id
2245: and ticb.item_context_id = hic.item_context_id
2246: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

Line 2530: ,hr_item_contexts hic

2526: -- segments can be null need this check
2527: select template_item_context_id
2528: into x_template_item_context_id
2529: from hr_template_item_contexts_b ticb
2530: ,hr_item_contexts hic
2531: ,fnd_id_flex_structures fifs
2532: where ticb.template_item_id = x_template_item_id
2533: and ticb.item_context_id = hic.item_context_id
2534: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)