APPS.PA_PAXMGSLS_XMLP_PKG SQL Statements

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

Line: 28

      SELECT
        trim(replace(MEANING,'*',''))
      INTO NDF
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
        AND LOOKUP_TYPE = 'MESSAGE';

Line: 39

        SELECT
          trim(replace(MEANING,'*',''))
        INTO NDF
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 56

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL
    WHERE GL.SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;

Line: 115

      SELECT
        MEANING
      INTO SOME_VAR
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = MANUFACTURING_RELATED
        AND LOOKUP_TYPE = 'YES_NO';

Line: 125

        SELECT
          MEANING
        INTO SOME_VAR
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 252

    SELECT
      CURRENCY_CODE
    INTO L_CURR_CODE
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;