APPS.BOM_CSTRPCRE_XMLP_PKG SQL Statements

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

Line: 11

      SELECT cod.organization_name,
             sob.currency_code
      INTO   P_ORG_NAME,
             l_currency
      FROM   cst_organization_definitions cod,
             gl_sets_of_books sob
      WHERE  cod.organization_id = P_ORG_ID
      AND    cod.set_of_books_id = sob.set_of_books_id;

Line: 31

      select	nvl(minimum_accountable_unit, power(10,nvl(-precision,0)))
      into	P_ROUND_UNIT
      from fnd_currencies
      where currency_code = P_CURRENCY_CODE;

Line: 45

              MODE="SELECT"
              OUTPUT=":P_ITEM_SEG"
              DISPLAY="ALL"
              TABLEALIAS="MSI"');*/NULL;

Line: 85

    SELECT
      PERIOD_START_DATE,
      SCHEDULE_CLOSE_DATE
    INTO L_EARLIEST_TO_DATE,L_LATEST_TO_DATE
    FROM
      ORG_ACCT_PERIODS
    WHERE ORGANIZATION_ID = P_ORG_ID
      AND ACCT_PERIOD_ID = P_PERIOD_ID;

Line: 119

    SELECT
      CONCURRENT_PROGRAM_ID
    INTO L_CSTRPCRE_PROG_ID
    FROM
      FND_CONCURRENT_PROGRAMS
    WHERE APPLICATION_ID = 702
      AND CONCURRENT_PROGRAM_NAME = 'CSTRPCRE';

Line: 128

      SELECT
        NVL(SUMMARIZED_FLAG
           ,'N'),
        DECODE(OPEN_FLAG
              ,'N'
              ,0
              ,1),
        DECODE(OPEN_FLAG
              ,'N'
              ,L_LATEST_TO_DATE
              ,L_P_TO_DATE)
      INTO L_SUMMARIZED_FLAG,L_PERIOD_OPEN_FLAG,L_P_TO_DATE
      FROM
        ORG_ACCT_PERIODS
      WHERE ORGANIZATION_ID = P_ORG_ID
        AND ACCT_PERIOD_ID = P_PERIOD_ID;

Line: 145

      SELECT
        MIN(FCR.REQUEST_ID)
      INTO L_OTHER_REQUEST_ID
      FROM
        FND_CONCURRENT_REQUESTS FCR
      WHERE FCR.PROGRAM_APPLICATION_ID = 702
        AND FCR.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
        AND FCR.ARGUMENT1 = TO_CHAR(P_ORG_ID)
        AND FCR.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)
        AND FCR.PHASE_CODE = 'R'
        AND FCR.ACTUAL_START_DATE = (
        SELECT
          MIN(FCR2.ACTUAL_START_DATE)
        FROM
          FND_CONCURRENT_REQUESTS FCR2
        WHERE FCR2.PROGRAM_APPLICATION_ID = 702
          AND FCR2.CONCURRENT_PROGRAM_ID = L_CSTRPCRE_PROG_ID
          AND FCR2.ARGUMENT1 = TO_CHAR(P_ORG_ID)
          AND FCR2.ARGUMENT5 = TO_CHAR(P_PERIOD_ID)
          AND FCR2.PHASE_CODE = 'R' );

Line: 254

    SELECT
      PERIOD_START_DATE,
      PERIOD_NAME
    INTO P_FROM_DATE,P_PERIOD_NAME
    FROM
      ORG_ACCT_PERIODS
    WHERE ORGANIZATION_ID = P_ORG_ID
      AND ACCT_PERIOD_ID = P_PERIOD_ID;

Line: 263

    SELECT
      ENABLE_TRACE
    INTO L_ENABLE_TRACE
    FROM
      FND_CONCURRENT_PROGRAMS
    WHERE CONCURRENT_PROGRAM_NAME = 'CSTRPCRE'
      AND APPLICATION_ID = 702;

Line: 271

    SELECT
      MEANING
    INTO P_NULLSUB
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'CST_PER_CLOSE_MISC'
      AND LOOKUP_CODE = 1;