APPS.BOM_CSTRPWRO_XMLP_PKG SQL Statements

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

Line: 13

      SELECT
        NAME
      INTO LEGAL_ENTITY_NAME
      FROM
        XLE_FIRSTPARTY_INFORMATION_V
      WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY;

Line: 19

      SELECT
        COST_TYPE
      INTO COST_TYPE_NAME
      FROM
        CST_COST_TYPES
      WHERE COST_TYPE_ID = P_COST_TYPE;

Line: 25

      SELECT
        COST_GROUP
      INTO COST_GROUP_NAME
      FROM
        CST_COST_GROUPS
      WHERE COST_GROUP_ID = P_COST_GROUP
        AND LEGAL_ENTITY = P_LEGAL_ENTITY;

Line: 32

      SELECT
        PERIOD_NAME
      INTO PERIOD_NAME
      FROM
        CST_PAC_PERIODS
      WHERE PAC_PERIOD_ID = P_PERIOD_ID
        AND COST_TYPE_ID = P_COST_TYPE
        AND LEGAL_ENTITY = P_LEGAL_ENTITY;

Line: 40

      SELECT
        FND_DATE.DATE_TO_CANONICAL(PERIOD_START_DATE),
        FND_DATE.DATE_TO_CANONICAL(PERIOD_END_DATE),
        TO_CHAR(PERIOD_START_DATE
               ,'DD-MON-RRRR'),
        TO_CHAR(PERIOD_END_DATE
               ,'DD-MON-RRRR')
      INTO P_WRITE_OFF_DATE_FROM,P_WRITE_OFF_DATE_TO,FROM_DATE,TO_DATE
      FROM
        CST_PAC_PERIODS CPP
      WHERE CPP.PAC_PERIOD_ID = P_PERIOD_ID
        AND CPP.LEGAL_ENTITY = P_LEGAL_ENTITY
        AND CPP.COST_TYPE_ID = P_COST_TYPE;

Line: 67

    SELECT
      GSOB.CHART_OF_ACCOUNTS_ID
    INTO L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS GSOB,
      FINANCIALS_SYSTEM_PARAMETERS FSP
    WHERE FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID;