APPS.BOM_CSTRTVHA_XMLP_PKG SQL Statements

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

Line: 14

    SELECT  COUNT(*)
    INTO L_AVG_ORG_COUNT
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = P_ORG_ID
      AND PRIMARY_COST_METHOD IN ( 2 , 5 , 6 );

Line: 40

    SELECT
      OOD.ORGANIZATION_NAME,
      SOB.CURRENCY_CODE,
      FC.PRECISION,
      MCS.CATEGORY_SET_NAME,
      LOOKUP1.MEANING,
      STYPE1.TRANSACTION_SOURCE_TYPE_NAME,
      STYPE2.TRANSACTION_SOURCE_TYPE_NAME,
      STYPE3.TRANSACTION_SOURCE_TYPE_NAME,
      STYPE4.TRANSACTION_SOURCE_TYPE_NAME
    INTO PV_ORGANIZATION_NAME,PV_CURRENCY_CODE,PV_STD_PREC,PV_CATEGORY_SET_NAME,PV_SORT_OPTION,PV_STYPE1,PV_STYPE2,PV_STYPE3,PV_STYPE4
    FROM
      ORG_ORGANIZATION_DEFINITIONS OOD,
      GL_SETS_OF_BOOKS SOB,
      FND_CURRENCIES FC,
      MTL_CATEGORY_SETS MCS,
      MFG_LOOKUPS LOOKUP1,
      MTL_TXN_SOURCE_TYPES STYPE1,
      MTL_TXN_SOURCE_TYPES STYPE2,
      MTL_TXN_SOURCE_TYPES STYPE3,
      MTL_TXN_SOURCE_TYPES STYPE4
    WHERE OOD.ORGANIZATION_ID = P_ORG_ID
      AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
      AND FC.CURRENCY_CODE = SOB.CURRENCY_CODE
      AND MCS.CATEGORY_SET_ID = P_CAT_SET_ID
      AND LOOKUP1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
      AND LOOKUP1.LOOKUP_CODE = P_SORT_OPTION
      AND STYPE1.TRANSACTION_SOURCE_TYPE_ID = P_STYPE1
      AND STYPE2.TRANSACTION_SOURCE_TYPE_ID = P_STYPE2
      AND STYPE3.TRANSACTION_SOURCE_TYPE_ID = P_STYPE3
      AND STYPE4.TRANSACTION_SOURCE_TYPE_ID = P_STYPE4;