APPS.IEU_PLGN_FUNC_PVT SQL Statements

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

Line: 83

  l_deleted_flag        VARCHAR2(1);

Line: 90

  l_deleted_flag := 'D';

Line: 117

    SELECT val.value
    INTO l_nosoft_mode
    FROM CCT_MIDDLEWARE_PARAMS par,
         CCT_MIDDLEWARE_VALUES val,
         CCT_MIDDLEWARES mid
    WHERE mid.MIDDLEWARE_ID = val.MIDDLEWARE_ID
    AND par.MIDDLEWARE_PARAM_ID = val.MIDDLEWARE_PARAM_ID
    AND (mid.F_DELETEDFLAG is null OR mid.F_DELETEDFLAG <> l_deleted_flag)
    AND (par.F_DELETEDFLAG is null OR par.F_DELETEDFLAG <> l_deleted_flag)
    AND (val.F_DELETEDFLAG is null OR val.F_DELETEDFLAG <> l_deleted_flag)
    AND par.NAME = l_soft_disabled_param
    AND mid.MIDDLEWARE_ID =
        (SELECT tel.MIDDLEWARE_ID
         FROM CCT_TELESETS tel
         WHERE tel.TELESET_HARDWARE_NUMBER = to_char(P_AGENT_EXTN)
         AND (tel.F_DELETEDFLAG is null OR tel.F_DELETEDFLAG <> l_deleted_flag)
         AND tel.SERVER_GROUP_ID =
             (SELECT res.SERVER_GROUP_ID
              FROM JTF_RS_RESOURCE_EXTNS res
              WHERE res.RESOURCE_ID = P_RESOURCE_ID) );

Line: 186

        SELECT DISTINCT
          ptable.class_name
        INTO
          l_class
        FROM
          IEU_CTL_PLUGINS_B ptable
        WHERE
          l_classes(i) = ptable.class_name;

Line: 255

        SELECT DISTINCT
          cliprov.PLUGIN_CLASS_NAME,
          climap.CONDITIONAL_FUNC
        INTO
          l_class,
          l_cond_launch_func
        FROM
          IEU_CLI_PROV_PLUGINS cliprov,
          IEU_CLI_PROV_PLUGIN_MED_MAPS climap
        WHERE
          climap.MEDIA_TYPE_ID = l_media_types(i).media_type_id
          AND climap.PLUGIN_ID =  cliprov.PLUGIN_ID;