APPS.FII_UDD2_MAINTAIN_PKG dependencies on FND_FLEX_VALUES

Line 100: from fnd_flex_values

96: FII_MESSAGE.Func_Ent (func_name => 'Get_Flex_Value');
97: end if;
98:
99: select flex_value into l_flex_value
100: from fnd_flex_values
101: where flex_value_id = p_flex_value_id;
102:
103: if FIIDIM_Debug then
104: FII_MESSAGE.Func_Succ (func_name => 'Get_Flex_Value');

Line 592: fnd_flex_values ffv

588: IS
589:
590: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
591: FROM FII_DIM_NORM_HIER_GT ffvnh,
592: fnd_flex_values ffv
593: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
594: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
595: AND ffvnh.child_flex_value_high)
596: AND ((ffvnh.range_attribute = 'P' and ffv.summary_flag = 'Y') OR

Line 608: from fnd_flex_values

604:
605: BEGIN
606:
607: select flex_value_id, attribute_sort_order into l_flex_value_id, l_sort_order
608: from fnd_flex_values
609: where flex_value_set_id = p_vset_id
610: and flex_value = p_root_node;
611:
612: l_flex_value_set_id := p_vset_id;

Line 724: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';

720:
721: UDIM2_parent_node := p_root_node;
722: UDIM2_parent_vset_id := p_vset_id;
723:
724: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
725:
726: SELECT flex_value_id INTO p_parent_id
727: FROM FND_FLEX_VALUES
728: WHERE flex_value_set_id = p_vset_id

Line 727: FROM FND_FLEX_VALUES

723:
724: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
725:
726: SELECT flex_value_id INTO p_parent_id
727: FROM FND_FLEX_VALUES
728: WHERE flex_value_set_id = p_vset_id
729: AND flex_value = p_root_node;
730:
731: UDIM2_parent_flex_id := p_parent_id;