APPS.OKS_OKSFOSUM_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        NAME
      FROM
        HR_OPERATING_UNITS
      WHERE ORGANIZATION_ID = LP_OPERATING_UNIT;

Line: 36

      SELECT
        NAME
      FROM
        HR_OPERATING_UNITS
      WHERE ORGANIZATION_ID = LP_OPERATING_UNIT;

Line: 42

      SELECT
        NAME
      FROM
        OKC_K_GROUPS_V
      WHERE ID = CN_CONTRACT_GROUP_ID;

Line: 81

    DELETE FROM OKS_STATUS_FORECAST
     WHERE CONC_REQUEST_ID = P_CONC_REQUEST_ID;