1539: , V.FLEX_VALUE
1540: , V.SUMMARY_FLAG
1541: , substr(v2.compiled_value_attributes,5,1)
1542: FROM FND_FLEX_VALUES V
1543: , FND_FLEX_VALUE_NORM_HIERARCHY H
1544: , FND_FLEX_VALUES V2
1545: WHERE v.flex_value_set_id = l_flex_value_set_id
1546: AND h.flex_value_set_id = l_flex_value_set_id
1547: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH
1569: , v.SUMMARY_FLAG
1570: , jca.parent_type
1571: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
1572: , FND_FLEX_VALUES v
1573: , FND_FLEX_VALUE_NORM_HIERARCHY h
1574: WHERE jca.child_account = h.parent_flex_value
1575: AND v.flex_value_set_id = l_flex_value_set_id
1576: AND h.flex_value_set_id = l_flex_value_set_id
1577: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH