APPS.AP_APXBCRPT_XMLP_PKG SQL Statements

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

Line: 18

          SELECT
            SORT_BY_ALTERNATE_FIELD
          INTO H_SORT_BY_PHONETIC
          FROM
            AP_SYSTEM_PARAMETERS;

Line: 42

          SELECT
            GSB.NAME,
            GSB.CURRENCY_CODE
          INTO H_COMPANY_NAME,H_CURRENCY_CODE
          FROM
            GL_SETS_OF_BOOKS GSB,
            AP_SYSTEM_PARAMETERS ASP
          WHERE GSB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
            AND ROWNUM < 2;

Line: 59

          SELECT
            GSB.NAME,
            GSB.CURRENCY_CODE
          INTO H_COMPANY_NAME,H_CURRENCY_CODE
          FROM
            GL_SETS_OF_BOOKS GSB,
            AR_SYSTEM_PARAMETERS ASP
          WHERE GSB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
            AND ROWNUM < 2;

Line: 111

      SELECT
        DISPLAYED_FIELD
      INTO L_TRANSFER_PRIORITY
      FROM
        AP_LOOKUP_CODES
      WHERE LOOKUP_TYPE = 'TRANSFER_PRIORITY'
        AND LOOKUP_CODE = C_TRANSFER_PRIORITY;