APPS.JA_CN_GSSM_EXP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

    SELECT DECODE(SUBSTR(B.LOOKUP_CODE,LENGTH(B.LOOKUP_CODE)-2,3)
             , '999', ''   --For the blank lines
             ,B.DESCRIPTION
           )
      FROM FND_LOOKUP_VALUES B
     WHERE B.LANGUAGE = userenv('LANG')
       AND b.lookup_type = l_lookup     --using variable l_lookup
     ORDER BY B.LOOKUP_CODE
          ;

Line: 70

    /*SELECT T.DESCRIPTION                       line
      FROM FND_FLEX_VALUES_TL                  T
          ,FND_FLEX_VALUES                     B
     WHERE B.FLEX_VALUE_ID = T.FLEX_VALUE_ID
       AND T.LANGUAGE = userenv('LANG')
       AND B.FLEX_VALUE_SET_ID=
          (SELECT V.FLEX_VALUE_SET_ID
             FROM FND_FLEX_VALUE_SETS V
            WHERE V.FLEX_VALUE_SET_NAME LIKE l_lookup --using variable l_lookup
          )
     ORDER BY B.FLEX_VALUE
          ;*/