在为法人主体添加平衡段值时选不到相应的平衡段值

1、在为1069公司添加平衡段值时，值集列表中无法选到需要的平衡段值，进一步对其后台取值逻辑进行分析

SELECT *
  FROM (SELECT FLEXVALUES.FLEX_VALUE, FLEXVALUES.DESCRIPTION
          FROM FND_FLEX_VALUES_VL FLEXVALUES
         WHERE FLEXVALUES.FLEX_VALUE_SET_ID = :1
           AND FLEXVALUES.SUMMARY_FLAG = 'N'
           AND NOT EXISTS
         (SELECT 'X'
                  FROM GL_LEGAL_ENTITIES_BSVS LEB
                 WHERE LEB.FLEX_VALUE_SET_ID = FLEXVALUES.FLEX_VALUE_SET_ID
                   AND LEB.FLEX_SEGMENT_VALUE = FLEXVALUES.FLEX_VALUE
                   AND LEB.LEGAL_ENTITY_ID IN
                       (SELECT LCD.OBJECT_ID
                          FROM GL_LEDGER_CONFIG_DETAILS LCD,
                               GL_LEDGER_CONFIG_DETAILS LCD2
                         WHERE LCD2.OBJECT_ID = :2
                           AND LCD2.OBJECT_TYPE_CODE = 'LEGAL_ENTITY'
                           AND LCD.CONFIGURATION_ID = LCD