APPS.FII_UDD1_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 591: fnd_flex_values ffv

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

Line 607: from fnd_flex_values

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

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

718:
719: UDIM1_parent_node := p_root_node;
720: UDIM1_parent_vset_id := p_vset_id;
721:
722: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
723:
724: SELECT flex_value_id INTO p_parent_id
725: FROM FND_FLEX_VALUES
726: WHERE flex_value_set_id = p_vset_id

Line 725: FROM FND_FLEX_VALUES

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