APPS.IEU_CTRL_PVT SQL Statements

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

Line: 36

     SELECT *
     FROM
       IEU_MSG_MESSAGES message_table
     WHERE
       message_table.RESOURCE_TYPE = 'RS_INDIVIDUAL' AND
       message_table.RESOURCE_ID   =  P_RESOURCE_ID AND
       message_table.STATUS_ID     <= P_STATUS_ID;

Line: 91

                               msg_val.LAST_UPDATE_DATE, msg_val.APPLICATION_ID,                               msg_val.RESOURCE_TYPE, msg_val.RESOURCE_ID,
                               msg_val.STATUS_ID, msg_val.TITLE,
                               msg_val.BODY, msg_val.WORKITEM_OBJ_CODE,
                               msg_val.WORKITEM_PK_ID );

Line: 131

    UPDATE IEU_MSG_MESSAGES SET
        IEU_MSG_MESSAGES.STATUS_ID = P_CTRL_MESSAGES_NST(i).STATUS_ID,
        IEU_MSG_MESSAGES.LAST_UPDATE_DATE = SYSDATE
      WHERE P_CTRL_MESSAGES_NST(i).MESSAGE_ID =
        IEU_MSG_MESSAGES.MESSAGE_ID;

Line: 193

  SELECT userenv('LANGUAGE') INTO X_EXISTING_LANG FROM DUAL;

Line: 226

     SELECT * FROM
       IEU_CTL_PLUGINS_B;

Line: 261

     SELECT tl.NAME, tl.DESCRIPTION INTO l_label_name, l_desc
           FROM IEU_CTL_PLUGINS_TL tl
           WHERE tl.PLUGIN_ID = msg_val.PLUGIN_ID AND
                 tl.LANGUAGE = userenv( 'LANG' );

Line: 443

     SELECT
       lookup_table.LOOKUP_CODE,
       lookup_table.MEANING
     FROM
       FND_LOOKUP_VALUES_VL lookup_table
     WHERE
       lookup_table.LOOKUP_TYPE = P_LOOKUP_TYPE AND
       lookup_table.VIEW_APPLICATION_ID = P_APP_ID AND
       lookup_table.ENABLED_FLAG = 'Y';

Line: 517

     SELECT
       lookup_table.LOOKUP_CODE,
       lookup_table.MEANING
     FROM
       FND_LOOKUP_VALUES_VL lookup_table
     WHERE
       lookup_table.LOOKUP_TYPE = P_LOOKUP_TYPE AND
       lookup_table.VIEW_APPLICATION_ID = P_APP_ID AND
       lookup_table.ENABLED_FLAG = 'Y'
     ORDER BY lookup_table.MEANING;

Line: 590

     SELECT
       lookup_table.LOOKUP_CODE,
       lookup_table.MEANING
     FROM
       FND_LOOKUP_VALUES_VL lookup_table
     WHERE
       lookup_table.LOOKUP_TYPE = p_lookup_type AND
       lookup_table.VIEW_APPLICATION_ID = P_APP_ID AND
       lookup_table.ENABLED_FLAG = 'Y';