APPS.BOM_CSTGILEV_XMLP_PKG SQL Statements

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

Line: 35

    SELECT
      XFI.NAME,
      GSOB.CURRENCY_CODE
    INTO H_LEGAL_ENTITY,H_CURRENCY
    FROM
      XLE_FIRSTPARTY_INFORMATION_V XFI,
      CST_LE_COST_TYPES CLCT,
      GL_SETS_OF_BOOKS GSOB
    WHERE XFI.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
      AND CLCT.LEGAL_ENTITY = XFI.LEGAL_ENTITY_ID
      AND CLCT.COST_TYPE_ID = P_COST_TYPE_ID
      AND CLCT.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID;

Line: 47

    SELECT
      COST_GROUP,
      DESCRIPTION
    INTO H_COST_GROUP,H_COST_GROUP_DESC
    FROM
      CST_COST_GROUPS
    WHERE COST_GROUP_ID = P_COST_GROUP_ID;

Line: 54

    SELECT
      COST_TYPE,
      DESCRIPTION
    INTO H_COST_TYPE,H_COST_TYPE_DESC
    FROM
      CST_COST_TYPES
    WHERE COST_TYPE_ID = P_COST_TYPE_ID;

Line: 61

    SELECT
      PERIOD_NAME,
      PERIOD_YEAR
    INTO H_PERIOD,H_FISCAL_YEAR
    FROM
      CST_PAC_PERIODS
    WHERE PAC_PERIOD_ID = P_PAC_PERIOD_ID;

Line: 68

    SELECT
      MAX(TO_CHAR(PROCESS_UPTO_DATE
                 ,' DD-MON-RR'))
    INTO H_UPTO_DATE
    FROM
      CST_PAC_PROCESS_PHASES
    WHERE COST_GROUP_ID = P_COST_GROUP_ID
      AND PAC_PERIOD_ID = P_PAC_PERIOD_ID;