DBA Data[Home] [Help]

APPS.GMF_UTILITIES_GRP dependencies on FND_FLEX_VALUES_VL

Line 252: fnd_flex_values_vl VAL

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'
256: AND FND.flex_value_set_id = VAL.flex_value_set_id

Line 263: l_description fnd_flex_values_vl.description%TYPE;

259: AND NVL(VAL.description,' ') = NVL(null, NVL(VAL.description,' '))
260: AND VAL.summary_flag = 'N'
261: AND fnd.id_flex_code = 'GL#';
262:
263: l_description fnd_flex_values_vl.description%TYPE;
264: begin
265: open cur_description(p_segment_num, p_segment_value, p_chart_of_accounts_id);
266: fetch cur_description into l_description;
267: close cur_description;