DBA Data[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 1543: , FND_FLEX_VALUE_NORM_HIERARCHY H

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

Line 1573: , FND_FLEX_VALUE_NORM_HIERARCHY h

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