APPS.FND_FLEX_DSC_API dependencies on FND_LOOKUP_VALUES

Line 1494: FROM fnd_flex_value_sets v, fnd_lookup_values vt,

1490: -- this should really be in the value sets package
1491: BEGIN
1492: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1493: NULL INTO dummy
1494: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1495: fnd_lookup_values ft
1496: WHERE v.flex_value_set_id = value_set_id_i
1497: AND vt.lookup_type = 'SEG_VAL_TYPES'
1498: AND vt.lookup_code = v.validation_type

Line 1495: fnd_lookup_values ft

1491: BEGIN
1492: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1493: NULL INTO dummy
1494: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1495: fnd_lookup_values ft
1496: WHERE v.flex_value_set_id = value_set_id_i
1497: AND vt.lookup_type = 'SEG_VAL_TYPES'
1498: AND vt.lookup_code = v.validation_type
1499: AND ft.lookup_type = 'FIELD_TYPE'

Line 1761: FROM fnd_flex_value_sets v, fnd_lookup_values vt,

1757: -- this should really be in the value sets package
1758: BEGIN
1759: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1760: NULL INTO dummy
1761: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1762: fnd_lookup_values ft
1763: WHERE v.flex_value_set_id = l_flex_value_set_id
1764: AND vt.lookup_type = 'SEG_VAL_TYPES'
1765: AND vt.lookup_code = v.validation_type

Line 1762: fnd_lookup_values ft

1758: BEGIN
1759: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1760: NULL INTO dummy
1761: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1762: fnd_lookup_values ft
1763: WHERE v.flex_value_set_id = l_flex_value_set_id
1764: AND vt.lookup_type = 'SEG_VAL_TYPES'
1765: AND vt.lookup_code = v.validation_type
1766: AND ft.lookup_type = 'FIELD_TYPE'