DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 1721: ,fnd_id_flex_structures fifs

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

Line 2243: ,fnd_id_flex_structures fifs

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

Line 2531: ,fnd_id_flex_structures fifs

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