APPS.IES_DEPL_SCRIPT_PKG SQL Statements

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

Line: 18

 SELECT dscript_id
   INTO l_script_id
   FROM ies_deployed_scripts
  WHERE dscript_name = p_script_name
    AND dscript_lang_id = (SELECT language_id
			     FROM fnd_languages
			    WHERE nls_language = p_script_language)
    AND active_status = 1;

Line: 68

    EXECUTE IMMEDIATE 'UPDATE ies_deployed_scripts SET lock_status = 1 '||
                    'WHERE DSCRIPT_ID = :dscriptId' USING p_dscript_id;

Line: 182

    SELECT dscript_id
      INTO l_dscript_id
      FROM ies_deployed_scripts
     WHERE dscript_name = (SELECT dscript_name
                                FROM ies_deployed_scripts
                               WHERE dscript_id = p_dscript_id)
       AND dscript_lang_id = (SELECT dscript_lang_id
                                FROM ies_deployed_scripts
                               WHERE dscript_id = p_dscript_id)
       AND active_status = 1;