DBA Data[Home] [Help]

APPS.GCS_VALUE_SET_PKG dependencies on FND_FLEX_VALUE_SETS

Line 27: FROM fnd_flex_value_sets

23: fnd_file.put_line(fnd_file.log, 'Creating Entity Value Set for ICM Integration.');
24:
25: SELECT flex_value_set_id
26: INTO l_flex_value_set_id
27: FROM fnd_flex_value_sets
28: WHERE flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
29:
30: MERGE INTO fnd_flex_values ffv
31: USING (SELECT feb.entity_id,

Line 235: FROM fnd_flex_value_sets

231: AND feb.entity_id = ghb.top_entity_id;
232:
233: SELECT flex_value_set_id
234: INTO l_flex_value_set_id
235: FROM fnd_flex_value_sets
236: WHERE flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
237:
238: DELETE fnd_flex_value_norm_hierarchy
239: WHERE flex_value_set_id = l_flex_value_set_id;