APPS.CE_CEFCERR_XMLP_PKG SQL Statements

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

Line: 10

        SELECT
          L.MEANING
        INTO
          C_ALL_TRANSLATION
        FROM
          CE_LOOKUPS L
        WHERE L.LOOKUP_TYPE = 'LITERAL'
          AND L.LOOKUP_CODE = 'ALL';

Line: 24

          SELECT
            CFH.NAME,
            CF.FORECAST_CURRENCY,
            CF.NAME
          INTO
            C_TEMPLATE_NAME
            ,C_FORECAST_CURRENCY
            ,C_FORECAST_NAME
          FROM
            CE_FORECAST_HEADERS CFH,
            CE_FORECASTS CF,
            CE_LOOKUPS L
          WHERE L.LOOKUP_TYPE = 'FORECAST_AGING_TYPE'
            AND L.LOOKUP_CODE = CFH.AGING_TYPE
            AND CFH.FORECAST_HEADER_ID = CF.FORECAST_HEADER_ID
            AND CF.FORECAST_ID = P_FORECAST_ID;