APPS.BOM_CSTRPCGW_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        count(*)
      INTO WMS_ORG_COUNT
      FROM
        MTL_PARAMETERS
      WHERE WMS_ENABLED_FLAG = 'Y'
        AND ORGANIZATION_ID = P_ORG_ID;

Line: 16

      SELECT
        count(*)
      INTO PJM_ORG_COUNT
      FROM
        MTL_PARAMETERS
      WHERE COST_GROUP_ACCOUNTING = 1
        AND PROJECT_REFERENCE_ENABLED = 1
        AND ORGANIZATION_ID = P_ORG_ID;