APPS.BOM_CSTREIVR_XMLP_PKG SQL Statements

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

Line: 24

      SELECT
        O.ORGANIZATION_NAME,
        MP.COST_ORGANIZATION_ID,
        NVL(MINIMUM_ACCOUNTABLE_UNIT
           ,POWER(10
                ,NVL(-PRECISION
                   ,0))),
        MCS.CATEGORY_SET_NAME,
        LU1.MEANING,
        LU2.MEANING,
        USERENV('SESSIONID')
      INTO P_ORGANIZATION,P_COST_ORG_ID,ROUND_UNIT,P_CAT_SET_NAME,P_SORT_BY,P_DETAIL_LEVEL,P_SESSIONID
      FROM
        ORG_ORGANIZATION_DEFINITIONS O,
        MTL_PARAMETERS MP,
        FND_CURRENCIES FC,
        MTL_CATEGORY_SETS MCS,
        MFG_LOOKUPS LU1,
        MFG_LOOKUPS LU2
      WHERE FC.CURRENCY_CODE = P_CURRENCY_CODE
        AND O.ORGANIZATION_ID = P_ORG_ID
        AND MP.ORGANIZATION_ID = P_ORG_ID
        AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
        AND LU1.LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT'
        AND LU1.LOOKUP_CODE = P_SORT_OPTION
        AND LU2.LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION'
        AND LU2.LOOKUP_CODE = P_RPT_OPTION;

Line: 52

      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: 61

      SELECT
        DEFAULT_COST_TYPE_ID,
        COST_TYPE
      INTO P_DEF_COST_TYPE,P_COST_TYPE
      FROM
        CST_COST_TYPES
      WHERE COST_TYPE_ID = P_COST_TYPE_ID;

Line: 151

      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;