APPS.BOM_CSTRPACQ_XMLP_PKG SQL Statements

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

Line: 8

SELECT fifst.id_flex_num

into p_item_flex_num

FROM fnd_id_flex_structures fifst

WHERE fifst.application_id = 401

AND fifst.id_flex_code = 'MSTK'

AND fifst.enabled_flag = 'Y'

AND fifst.freeze_flex_definition_flag = 'Y'

and rownum<2;

Line: 25

    SELECT
      XFI.NAME,
      GLL.CURRENCY_CODE
    INTO H_LEGAL_ENTITY,H_CURRENCY
    FROM
      XLE_FIRSTPARTY_INFORMATION_V XFI,
      GL_LEDGER_LE_V GLL
    WHERE XFI.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
      AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
      AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
      AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y';

Line: 36

    SELECT
      COST_GROUP
    INTO H_COST_GROUP
    FROM
      CST_COST_GROUPS
    WHERE COST_GROUP_ID = P_COST_GROUP_ID;

Line: 42

    SELECT
      COST_TYPE
    INTO H_COST_TYPE
    FROM
      CST_COST_TYPES
    WHERE COST_TYPE_ID = P_COST_TYPE_ID;

Line: 48

    SELECT
      PERIOD_NAME
    INTO H_PERIOD
    FROM
      CST_PAC_PERIODS
    WHERE PAC_PERIOD_ID = P_PERIOD_ID;

Line: 60

    SELECT
      MEANING
    INTO H_OPTION_FIELD
    FROM
      MFG_LOOKUPS
    WHERE LOOKUP_TYPE = 'CST_ACQ_REPORT_OPTION'
      AND LOOKUP_CODE = P_ALL_RECEIPTS;

Line: 72

    SELECT
      EXTENDED_PRECISION,
      NVL(MINIMUM_ACCOUNTABLE_UNIT
         ,POWER(10
              ,NVL(-PRECISION
                 ,0)))
    INTO P_EXT_PRECISION,P_PRECISION
    FROM
      FND_CURRENCIES
    WHERE CURRENCY_CODE = H_CURRENCY;