APPS.FII_CC_MAINTAIN_PKG dependencies on FND_FLEX_VALUES

Line 99: from fnd_flex_values

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

Line 586: fnd_flex_values ffv

582: IS
583:
584: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
585: FROM FII_DIM_NORM_HIER_GT ffvnh,
586: fnd_flex_values ffv
587: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
588: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
589: AND ffvnh.child_flex_value_high)
590: AND ((ffvnh.range_attribute = 'P' and ffv.summary_flag = 'Y') OR

Line 602: from fnd_flex_values

598:
599: BEGIN
600:
601: select flex_value_id, attribute_sort_order into l_flex_value_id, l_sort_order
602: from fnd_flex_values
603: where flex_value_set_id = p_vset_id
604: and flex_value = p_root_node;
605:
606: l_flex_value_set_id := p_vset_id;

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

713:
714: CCDIM_parent_node := p_root_node;
715: CCDIM_parent_vset_id := p_vset_id;
716:
717: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
718:
719: SELECT flex_value_id INTO p_parent_id
720: FROM FND_FLEX_VALUES
721: WHERE flex_value_set_id = p_vset_id

Line 720: FROM FND_FLEX_VALUES

716:
717: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
718:
719: SELECT flex_value_id INTO p_parent_id
720: FROM FND_FLEX_VALUES
721: WHERE flex_value_set_id = p_vset_id
722: AND flex_value = p_root_node;
723:
724: CCDIM_parent_flex_id := p_parent_id;