APPS.GL_FLEXFIELDS_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 500: FROM fnd_flex_value_norm_hierarchy

496: child_high IN VARCHAR2,
497: parent_num IN NUMBER) RETURN VARCHAR2 IS
498: CURSOR get_single_parent IS
499: SELECT min(parent_flex_value), count(*)
500: FROM fnd_flex_value_norm_hierarchy
501: WHERE flex_value_set_id = vs_id
502: AND child_flex_value_low = child_low
503: AND child_flex_value_high = child_high
504: AND range_attribute = 'C';

Line 508: FROM fnd_flex_value_norm_hierarchy

504: AND range_attribute = 'C';
505:
506: CURSOR get_parent IS
507: SELECT parent_flex_value
508: FROM fnd_flex_value_norm_hierarchy
509: WHERE flex_value_set_id = vs_id
510: AND child_flex_value_low = child_low
511: AND child_flex_value_high = child_high
512: AND range_attribute = 'C'

Line 517: FROM fnd_flex_value_norm_hierarchy

513: AND (parent_flex_value, child_flex_value_low,
514: child_flex_value_high) IN
515: (SELECT parent_flex_value, child_flex_value_low,
516: child_flex_value_high
517: FROM fnd_flex_value_norm_hierarchy
518: START with flex_value_set_id = vs_id
519: AND parent_flex_value = ancestor
520: CONNECT BY flex_value_set_id = vs_id
521: AND parent_flex_value BETWEEN PRIOR child_flex_value_low