DBA Data[Home] [Help]

APPS.FND_FLEX_HIERARCHIES_PKG dependencies on FND_FLEX_VALUE_SETS

Line 297: FROM fnd_flex_value_sets

293: l_rowid VARCHAR2(64);
294: BEGIN
295: SELECT flex_value_set_id
296: INTO l_flex_value_set_id
297: FROM fnd_flex_value_sets
298: WHERE flex_value_set_name = x_flex_value_set_name;
299:
300: BEGIN
301: SELECT hierarchy_id

Line 357: FROM fnd_flex_value_sets

353: (SELECT flex_value_set_id, hierarchy_id
354: FROM fnd_flex_hierarchies
355: WHERE (flex_value_set_id =
356: (SELECT flex_value_set_id
357: FROM fnd_flex_value_sets
358: WHERE flex_value_set_name = x_flex_value_set_name))
359: AND hierarchy_code = x_hierarchy_code))
360: AND userenv('LANG') in (language, source_lang);
361: END translate_row;