DBA Data[Home] [Help]

APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 85: AND NOT EXISTS ( SELECT 1 from fnd_flex_value_hierarchies

81: SELECT flex_value
82: FROM fnd_flex_values
83: WHERE flex_value_set_id = p_value_set_id
84: and flex_value NOT IN('4350','4201')
85: AND NOT EXISTS ( SELECT 1 from fnd_flex_value_hierarchies
86: where Flex_value_set_id = p_value_set_id
87: AND flex_value BETWEEN child_flex_value_low
88: AND child_flex_value_high
89: AND PARENT_FLEX_VALUE in ('4350','4201'))