DBA Data[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on FND_FLEX_VALUES_VL

Line 147: FROM fnd_flex_values_vl flv, FND_FLEX_VALUE_CHILDREN_V fchild,fnd_flex_values_vl flv2

143: AND organization_id = l_organization_id;
144:
145: CURSOR find_parent_recursive (l_child_id NUMBER) IS
146: SELECT nvl( flv2.flex_value_id, -1) parent_id
147: FROM fnd_flex_values_vl flv, FND_FLEX_VALUE_CHILDREN_V fchild,fnd_flex_values_vl flv2
148: WHERE flv.flex_value = fchild.flex_value (+)
149: AND flv.flex_value_set_id = fchild.flex_value_set_id (+)
150: AND flv2.flex_value(+) = fchild.parent_flex_value
151: AND flv2.flex_value_set_id(+) = fchild.flex_value_set_id