APPS.PA_PAXACMPT_XMLP_PKG SQL Statements

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

Line: 36

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

Line: 64

                                     ,P_DELETE_TMP_TABLE
                                     ,P_PROJECT_TYPE);

Line: 99

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

Line: 117

    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: 600

      SELECT
        SUBSTR(MEANING
              ,1
              ,10)
      INTO YES_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_ACTUAL_COST_FLAG;

Line: 612

      SELECT
        SUBSTR(MEANING
              ,1
              ,10)
      INTO YES_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_REVENUE_FLAG;

Line: 624

      SELECT
        SUBSTR(MEANING
              ,1
              ,10)
      INTO YES_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_BUDGETS_FLAG;

Line: 636

      SELECT
        SUBSTR(MEANING
              ,1
              ,10)
      INTO YES_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_COMMITMENT_FLAG;

Line: 674

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

Line: 689

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