APPS.BOM_CSTRAIVR_XMLP_PKG SQL Statements

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

Line: 31

    SELECT
      O.ORGANIZATION_NAME,
      MP.COST_ORGANIZATION_ID,
      SOB.CURRENCY_CODE,
      NVL(EXTENDED_PRECISION
         ,PRECISION),
      NVL(MINIMUM_ACCOUNTABLE_UNIT
         ,POWER(10
              ,NVL(-PRECISION
                 ,0))),
      MCS.CATEGORY_SET_NAME,
      DEFAULT_COST_TYPE_ID,
      COST_TYPE,
      LU1.MEANING
    INTO P_ORGANIZATION,P_COST_ORG_ID,L_FCN_CURRENCY,P_EXT_PREC,ROUND_UNIT,P_CAT_SET_NAME,P_DEF_COST_TYPE,P_COST_TYPE,P_SORT_BY
    FROM
      ORG_ORGANIZATION_DEFINITIONS O,
      MTL_PARAMETERS MP,
      GL_SETS_OF_BOOKS SOB,
      FND_CURRENCIES FC,
      MTL_CATEGORY_SETS MCS,
      CST_COST_TYPES,
      MFG_LOOKUPS LU1
    WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
      AND O.ORGANIZATION_ID = P_ORG_ID
      AND MP.ORGANIZATION_ID = P_ORG_ID
      AND SOB.SET_OF_BOOKS_ID = O.SET_OF_BOOKS_ID
      AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
      AND COST_TYPE_ID = P_COST_TYPE_ID
      AND LU1.LOOKUP_TYPE (+) = 'CST_ITEM_REPORT_SORT'
      AND LU1.LOOKUP_CODE (+) = P_SORT_OPTION;

Line: 123

    SELECT
      TO_CHAR(TO_DATE(P_AS_OF_DATE
                     ,'YYYY/MM/DD HH24:MI:SS')
             ,'DD-MON-YYYY HH24:MI:SS')
    INTO L_AS_OF_DATE
    FROM
      DUAL;