APPS.PA_PAXACRTA_XMLP_PKG SQL Statements

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

Line: 29

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

Line: 66

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

Line: 83

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 231

    SELECT
      SUBSTRB(FND_MESSAGE.GET
             ,1
             ,255)
    INTO TMP_MESSAGE
    FROM
      DUAL;

Line: 245

    SELECT
      SUBSTRB(FND_MESSAGE.GET
             ,1
             ,255)
    INTO TMP_LINE_EXCEPT
    FROM
      DUAL;