DBA Data[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 2425: , FND_FLEX_VALUE_NORM_HIERARCHY H

2421: , V.FLEX_VALUE
2422: , V.SUMMARY_FLAG
2423: , substr(v2.compiled_value_attributes,5,1)
2424: FROM FND_FLEX_VALUES V
2425: , FND_FLEX_VALUE_NORM_HIERARCHY H
2426: , FND_FLEX_VALUES V2
2427: WHERE v.flex_value_set_id = l_flex_value_set_id
2428: AND h.flex_value_set_id = l_flex_value_set_id
2429: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH

Line 2455: , FND_FLEX_VALUE_NORM_HIERARCHY h

2451: , v.SUMMARY_FLAG
2452: , jca.parent_type
2453: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
2454: , FND_FLEX_VALUES v
2455: , FND_FLEX_VALUE_NORM_HIERARCHY h
2456: WHERE jca.child_account = h.parent_flex_value
2457: AND v.flex_value_set_id = l_flex_value_set_id
2458: AND h.flex_value_set_id = l_flex_value_set_id
2459: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH