APPS.ONT_OEXAUCRC_XMLP_PKG SQL Statements

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

Line: 17

        SELECT
          NAME
        INTO RP_OPERATING_UNIT
        FROM
          HR_OPERATING_UNITS
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 30

        SELECT
          OTT.NAME,
          OOH.ORDER_NUMBER
        INTO RP_ORDER_TYPE,RP_ORDER_NUMBER
        FROM
          OE_ORDER_HEADERS_ALL OOH,
          OE_TRANSACTION_TYPES OTT
        WHERE OOH.HEADER_ID = P_HEADER_ID
          AND OOH.ORDER_TYPE_ID = OTT.TRANSACTION_TYPE_ID;

Line: 46

        SELECT
          MEANING
        INTO RP_ORDER_BY
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'CREDIT_CHECK_PROCESS_RULE'
          AND LOOKUP_CODE = P_ORDER_BY;