DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on HR_ITEM_CONTEXTS

Line 1806: ,hr_item_contexts hic

1802:
1803: select template_item_context_id
1804: into x_template_item_context_id
1805: from hr_template_item_contexts_b ticb
1806: ,hr_item_contexts hic
1807: ,fnd_id_flex_structures fifs
1808: where ticb.template_item_id = x_template_item_id
1809: and ticb.item_context_id = hic.item_context_id
1810: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

Line 2328: ,hr_item_contexts hic

2324: -- segments can be null need this check
2325: select template_item_context_id
2326: into x_template_item_context_id
2327: from hr_template_item_contexts_b ticb
2328: ,hr_item_contexts hic
2329: ,fnd_id_flex_structures fifs
2330: where ticb.template_item_id = x_template_item_id
2331: and ticb.item_context_id = hic.item_context_id
2332: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)

Line 2616: ,hr_item_contexts hic

2612: -- segments can be null need this check
2613: select template_item_context_id
2614: into x_template_item_context_id
2615: from hr_template_item_contexts_b ticb
2616: ,hr_item_contexts hic
2617: ,fnd_id_flex_structures fifs
2618: where ticb.template_item_id = x_template_item_id
2619: and ticb.item_context_id = hic.item_context_id
2620: and nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)