387: l_here_key_seg_val := l_akey_segment(l_here_key_seg_index);
388:
389: select parent_flex_value
390: into l_parent_value
391: from FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
392: fnd_flex_value_sets val_set
393: where val_norm.flex_value_set_id = val_set.flex_value_set_id
394: and val_set.flex_value_set_name = l_value_set_name
395: and l_here_key_seg_val between val_norm.child_flex_value_low and