DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 1807: ,fnd_id_flex_structures fifs

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)
1811: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)

Line 2329: ,fnd_id_flex_structures fifs

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)
2333: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)

Line 2617: ,fnd_id_flex_structures fifs

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)
2621: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)