APPS.IEU_CONSTS_PUB SQL Statements

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

Line: 8

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_INBOUND_TELEPHONY
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_INBOUND_TELEPHONY;  -- Niraj, Bug 4998176, Replaced value by Variable

Line: 23

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_INBOUND_EMAIL
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_INBOUND_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 38

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_OUTBOUND_TELEPHONY
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_OUTBOUND_TELEPHONY; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 53

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_ADV_OUTB_TELEPHONY
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_ADV_OUTB_TELEPHONY; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 68

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_OUTBOUND_EMAIL
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_OUTBOUND_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 83

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_WEB_CALLBACK
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_WEB_CALLBACK; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 98

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_WEB_COLLABORATION
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_WEB_COLLABORATION; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 113

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_DIRECT_EMAIL
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_DIRECT_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 128

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_BLENDED
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_BLENDED; -- Niraj, Bug 4998176, Replaced value by Variable

Line: 143

    SELECT
      DISTINCT
        TYPE_ID
      INTO
        G_STID_UWQ
      FROM
        IEO_SVR_TYPES_B
      WHERE
        TYPE_UUID = G_STUUID_UWQ;

Line: 158

    SELECT
      DISTINCT
        MEDIA_TYPE_ID
      INTO
        G_MTID_ACQUIRED_EMAIL
      FROM
        IEU_UWQ_MEDIA_TYPES_B
      WHERE
        MEDIA_TYPE_UUID = G_MTUUID_ACQUIRED_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable