200: AND include_exclude_indicator = 'I'
201: UNION
202: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
203: FROM fnd_flex_value_rule_lines l,
204: fnd_flex_value_hier_all h1,
205: fnd_flex_value_sets fv
206: WHERE l.flex_value_rule_id = rule_id
207: AND l.include_exclude_indicator = 'I'
208: AND h1.flex_value_set_id = l.flex_value_set_id
224: AND include_exclude_indicator <> 'I'
225: UNION
226: SELECT h1.child_flex_value_low low,h1.child_flex_value_high high
227: FROM fnd_flex_value_rule_lines l,
228: fnd_flex_value_hier_all h1,
229: fnd_flex_value_sets fv
230: WHERE l.flex_value_rule_id = rule_id
231: AND l.include_exclude_indicator <> 'I'
232: AND h1.flex_value_set_id = l.flex_value_set_id