APPS.BOM_CSTRACTC_XMLP_PKG SQL Statements

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

Line: 68

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

Line: 82

      SELECT
        OAP1.PERIOD_START_DATE,
        OAP2.SCHEDULE_CLOSE_DATE
      INTO P_PERIOD_DATE_FROM,P_PERIOD_DATE_TO
      FROM
        ORG_ACCT_PERIODS OAP1,
        ORG_ACCT_PERIODS OAP2
      WHERE OAP1.ORGANIZATION_ID = P_ORG_ID
        AND OAP1.ACCT_PERIOD_ID = P_PERIOD_ID_FROM
        AND OAP2.ORGANIZATION_ID = P_ORG_ID
        AND OAP2.ACCT_PERIOD_ID = P_PERIOD_ID_TO;

Line: 93

      SELECT
        OOD.ORGANIZATION_NAME,
        SOB.CURRENCY_CODE
      INTO P_ORG_NAME,L_CURRENCY
      FROM
        CST_ORGANIZATION_DEFINITIONS OOD,
        GL_SETS_OF_BOOKS SOB
      WHERE OOD.ORGANIZATION_ID = P_ORG_ID
        AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID;

Line: 109

      SELECT
        NVL(MINIMUM_ACCOUNTABLE_UNIT
           ,POWER(10
                ,NVL(-PRECISION
                   ,0)))
      INTO P_ROUND_UNIT
      FROM
        FND_CURRENCIES
      WHERE CURRENCY_CODE = P_CURRENCY_CODE;