APPS.AR_ARBRRMLT_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      SET_OF_BOOKS_ID
    INTO P_SET_OF_BOOKS_ID
    FROM
      AR_SYSTEM_PARAMETERS;

Line: 92

    SELECT
      PRINT_HOME_COUNTRY_FLAG,
      NVL(DEFAULT_COUNTRY
         ,'US')
    INTO L_PRINT_COUNTRY_FLAG,L_DEFAULT_COUNTRY
    FROM
      AR_SYSTEM_PARAMETERS;

Line: 113

        SELECT
          TERRITORY_SHORT_NAME
        INTO COUNTRY_DESCRIPTION
        FROM
          FND_TERRITORIES_VL
        WHERE TERRITORY_CODE = COUNTRY_CODE;

Line: 124

          SELECT
            TERRITORY_SHORT_NAME
          INTO COUNTRY_DESCRIPTION
          FROM
            FND_TERRITORIES_VL
          WHERE TERRITORY_CODE = COUNTRY_CODE;