APPS.ENI_PROD_VALUESET dependencies on FND_FLEX_VALUE_CHILDREN_V

Line 218: FROM FND_FLEX_VALUE_CHILDREN_V a, fnd_flex_values b

214: b.ENABLED_FLAG,
215: b.START_DATE_ACTIVE,
216: b.END_DATE_ACTIVE,
217: 'P'
218: FROM FND_FLEX_VALUE_CHILDREN_V a, fnd_flex_values b
219: WHERE a.FLEX_VALUE_SET_ID = l_flex_val_set_id
220: and a.flex_value_set_id = b.flex_value_set_id
221: and a.flex_value = b.flex_value
222: UNION

Line 234: from fnd_flex_value_children_v

230: 'P'
231: FROM FND_FLEX_VALUES A
232: WHERE flex_value_set_id = l_flex_val_set_id
233: AND not exists (Select flex_value
234: from fnd_flex_value_children_v
235: where flex_value_set_id = a.flex_value_set_id
236: and flex_value = a.flex_value);
237:
238: commit;