APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 10: from fnd_id_flex_segments

6: /*
7: function range_or_single(p_coa_id in number) return varchar2 as
8: cursor numSeg is
9: select count(*)
10: from fnd_id_flex_segments
11: where application_id = 101
12: and id_flex_code = 'GL#'
13: and id_flex_num = p_coa_id
14: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);

Line 36: from fnd_id_flex_segments

32: begin
33:
34: begin
35: select 1 into l_num
36: from fnd_id_flex_segments
37: where application_id = 101
38: and id_flex_code = 'GL#'
39: and id_flex_num = p_coa_id
40: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID)

Line 160: from fnd_id_flex_segments

156: select application_column_name,
157: flex_value_set_id
158: into col_name,
159: vsid
160: from fnd_id_flex_segments
161: where application_id = 101
162: and id_flex_code = 'GL#'
163: and id_flex_num = r.chart_of_accounts_id
164: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);

Line 251: from fnd_id_flex_segments fifs,

247: cursor segment(p_chart_of_accounts_id number,
248: p_segment_attribute_type varchar2) is
249: select fsav.application_column_name,
250: fifs.flex_value_set_id
251: from fnd_id_flex_segments fifs,
252: fnd_segment_attribute_values fsav
253: where fifs.application_id = 101
254: and fifs.id_flex_code = 'GL#'
255: and fifs.application_column_name = fsav.application_column_name

Line 274: from fnd_id_flex_segments

270:
271: cursor prod_val is
272: select application_column_name,
273: flex_value_set_id
274: from fnd_id_flex_segments
275: where application_id = 101
276: and id_flex_code = 'GL#'
277: and id_flex_num = p_chart_of_accounts_id
278: and flex_value_set_id = ENI_VALUESET_CATEGORY.Get_Flex_Value_Set_Id('401', 'MCAT', ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID);