APPS.GMF_UTILITIES_GRP dependencies on FND_ID_FLEX_SEGMENTS

Line 83: TYPE t_seg_num IS TABLE OF FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE INDEX BY BINARY_INTEGER;

79: l_chart_of_accounts_id NUMBER(15);
80: l_delimiter varchar2(5);
81: l_sql_stmt VARCHAR2(2000);
82:
83: TYPE t_seg_num IS TABLE OF FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE INDEX BY BINARY_INTEGER;
84:
85: CURSOR segments(chart_of_accounts_id NUMBER) IS SELECT
86: application_column_name
87: FROM

Line 88: fnd_id_flex_segments f

84:
85: CURSOR segments(chart_of_accounts_id NUMBER) IS SELECT
86: application_column_name
87: FROM
88: fnd_id_flex_segments f
89: WHERE
90: f.id_flex_num = chart_of_accounts_id and
91: f.application_id = 101 AND
92: f.id_flex_code = 'GL#' AND

Line 251: FROM fnd_id_flex_segments FND,

247: p_chart_of_accounts_id NUMBER
248: )
249: is
250: SELECT VAL.description
251: FROM fnd_id_flex_segments FND,
252: fnd_flex_values_vl VAL
253: WHERE FND.id_flex_num = p_chart_of_accounts_id
254: AND FND.segment_num = NVL(p_segment_num, FND.segment_num)
255: AND FND.enabled_flag = 'Y'