APPS.BOM_CSTRIVTI_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        SOB.CURRENCY_CODE
      INTO L_FCN_CURRENCY
      FROM
        GL_SETS_OF_BOOKS SOB,
        ORG_ORGANIZATION_DEFINITIONS OOD
      WHERE OOD.ORGANIZATION_ID = P_ORG_ID
        AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID;

Line: 17

      SELECT
        O.ORGANIZATION_NAME,
        NVL(MINIMUM_ACCOUNTABLE_UNIT
           ,POWER(10
                ,NVL(-PRECISION
                   ,0)))
      INTO CP_ORG_NAME,ROUND_UNIT
      FROM
        ORG_ORGANIZATION_DEFINITIONS O,
        FND_CURRENCIES FC
      WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
        AND O.ORGANIZATION_ID = P_ORG_ID;