APPS.IGI_CHECK_VERSION SQL Statements

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

Line: 37

   SELECT COUNT(1)
   INTO rowCnt
   FROM dba_users
   WHERE username = l_igo;

Line: 64

   SELECT COUNT(1)
   INTO rowCnt
   FROM all_objects
   WHERE object_name = 'JE_UK_GCC_INST_OPTIONS_ALL'
   AND owner = l_schema; -- Bug 3431843 hkaniven

Line: 98

   SELECT COUNT(1)
   INTO rowCnt
   FROM dba_users
   WHERE username = l_igi;

Line: 113

   insert INTO igi_inst_version
     (
     igi_opsfi_inst,
     igi_prev_ver,
     igi_igi_inst
     )
   values
     (
     l_igi_opsfi_inst,
     l_igi_prev_ver,
     l_igi_igi_inst
     );

Line: 155

    SELECT IGI_PREV_VER
    INTO l_igi_prev_ver
    FROM IGI_INST_VERSION;