APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on FND_FLEX_VALUES

Line 101: from fnd_flex_values

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

Line 611: fnd_flex_values ffv

607: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2) IS
608: SELECT /*+ leading(ffvnh) index(ffvnh) */
609: ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
610: FROM FII_DIM_NORM_HIER_GT ffvnh,
611: fnd_flex_values ffv
612: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
613: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
614: AND ffvnh.child_flex_value_high)
615: AND ((ffvnh.range_attribute = 'P' and ffv.summary_flag = 'Y') OR

Line 630: from fnd_flex_values

626: -- FII_MESSAGE.Func_Ent ('FII_COM_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
627: -- END IF;
628:
629: select flex_value_id, attribute_sort_order into l_flex_value_id, l_sort_order
630: from fnd_flex_values
631: where flex_value_set_id = p_vset_id
632: and flex_value = p_root_node;
633:
634: l_flex_value_set_id := p_vset_id;

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

736:
737: FINDIM_parent_node := p_root_node;
738: FINDIM_parent_vset_id := p_vset_id;
739:
740: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
741:
742: SELECT flex_value_id INTO p_parent_id
743: FROM FND_FLEX_VALUES
744: WHERE flex_value_set_id = p_vset_id

Line 743: FROM FND_FLEX_VALUES

739:
740: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
741:
742: SELECT flex_value_id INTO p_parent_id
743: FROM FND_FLEX_VALUES
744: WHERE flex_value_set_id = p_vset_id
745: AND flex_value = p_root_node;
746:
747: FINDIM_parent_flex_id := p_parent_id;