APPS.IEU_UWQ_UTIL_PUB SQL Statements

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

Line: 33

    SELECT c.application_id
      INTO l_app_id
    FROM   IEU_UWQ_MACTION_DEFS_B c
          ,IEU_UWQ_MEDIA_ACTIONS b
          ,IEU_UWQ_MEDIA_TYPES_B a
    WHERE B.RESP_ID = P_RESP_ID
      AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
      AND B.MEDIA_TYPE_ID  = A.MEDIA_TYPE_ID
      AND B.CLASSIFICATION = P_CLASSIFICATION
      AND C.MACTION_DEF_ID = B.MACTION_DEF_ID;

Line: 47

        SELECT c.application_id
          INTO l_app_id
        FROM   IEU_UWQ_MACTION_DEFS_B c
              ,IEU_UWQ_MEDIA_ACTIONS b
              ,IEU_UWQ_MEDIA_TYPES_B a
        WHERE  B.RESP_ID = P_RESP_ID
          AND  A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
          AND  B.MEDIA_TYPE_ID  = A.MEDIA_TYPE_ID
          AND  B.CLASSIFICATION is null
          AND  C.MACTION_DEF_ID = B.MACTION_DEF_ID;

Line: 61

            SELECT c.application_id
              INTO l_app_id
            FROM   IEU_UWQ_MACTION_DEFS_B c
                  ,IEU_UWQ_MEDIA_ACTIONS b
            WHERE  B.RESP_ID = P_RESP_ID
              AND  C.MACTION_DEF_ID = B.MACTION_DEF_ID
              AND  B.MEDIA_TYPE_ID = -1;

Line: 72

              SELECT c.application_id
                INTO l_app_id
              FROM   IEU_UWQ_MACTION_DEFS_B c
                    ,IEU_UWQ_MEDIA_ACTIONS b
                    ,IEU_UWQ_MEDIA_TYPES_B a
              WHERE  ( B.RESP_ID = -1
                 OR    B.RESP_ID IS NULL )
                AND  A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
                AND  B.MEDIA_TYPE_ID  = A.MEDIA_TYPE_ID
                AND  B.CLASSIFICATION = P_CLASSIFICATION
                AND  C.MACTION_DEF_ID = B.MACTION_DEF_ID;

Line: 87

                SELECT c.application_id
                  INTO l_app_id
                FROM   IEU_UWQ_MACTION_DEFS_B c
                      ,IEU_UWQ_MEDIA_ACTIONS b
                      ,IEU_UWQ_MEDIA_TYPES_B a
                WHERE ( B.RESP_ID = -1
                   OR   B.RESP_ID IS NULL )
                  AND A.MEDIA_TYPE_UUID = P_MEDIA_TYPE_UUID
                  AND B.MEDIA_TYPE_ID  = A.MEDIA_TYPE_ID
                  AND B.CLASSIFICATION is null
                  AND C.MACTION_DEF_ID = B.MACTION_DEF_ID;

Line: 101

                SELECT c.application_id
                  INTO l_app_id
                FROM   IEU_UWQ_MACTION_DEFS_B c
                      ,IEU_UWQ_MEDIA_ACTIONS b
                      ,IEU_UWQ_MEDIA_TYPES_B a
                WHERE ( B.RESP_ID = -1
                   OR   B.RESP_ID IS NULL )
                  AND B.MEDIA_TYPE_ID  = -1
                  AND B.CLASSIFICATION is null
                  AND C.MACTION_DEF_ID = B.MACTION_DEF_ID;