APPS.IGS_UC_GEN_001 SQL Statements

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

Line: 28

  SELECT configured_cycle
    FROM IGS_UC_DEFAULTS
   WHERE system_code = NVL(p_system_code, 'U');

Line: 46

         OPEN  l_result FOR SELECT appno, checkdigit, surname, forenames, birthdate, sex, title FROM igs_uc_u_cvname_2003 WHERE appno = p_appno;

Line: 48

         OPEN l_result FOR SELECT appno FROM igs_uc_u_cvname_2003 WHERE appno = p_appno;

Line: 50

         OPEN l_result FOR  SELECT appno FROM igs_uc_u_cvname_2003 WHERE (INDEXSURN = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate)) OR appno = p_appno;

Line: 52

         OPEN l_result FOR SELECT count(*) count1 FROM igs_uc_u_cvname_2003 WHERE INDEXSURN = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate);

Line: 64

             OPEN  l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8), checkdigit, surname, forenames, birthdate, sex, title FROM igs_uc_u_cvname_2003 WHERE appno IN (l_appno, l_appno_pad);

Line: 66

             OPEN l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_u_cvname_2003 WHERE appno IN (l_appno, l_appno_pad);

Line: 68

             OPEN l_result FOR  SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_u_cvname_2003 WHERE (UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate)) OR appno IN (l_appno, l_appno_pad);

Line: 70

             OPEN l_result FOR SELECT count(*) count1 FROM igs_uc_u_cvname_2003 WHERE UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate);

Line: 76

             OPEN  l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8), checkdigit, surname, forenames, birthdate, sex, title FROM igs_uc_g_cvgname_2006 WHERE appno IN (l_appno, l_appno_pad);

Line: 78

             OPEN l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_g_cvgname_2006 WHERE appno IN (l_appno, l_appno_pad);

Line: 80

             OPEN l_result FOR  SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_g_cvgname_2006 WHERE (UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate)) OR appno IN (l_appno, l_appno_pad);

Line: 82

             OPEN l_result FOR SELECT count(*) count1 FROM igs_uc_g_cvgname_2006 WHERE UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate);

Line: 88

             OPEN  l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8), checkdigit, surname, forenames, birthdate, sex, title FROM igs_uc_n_cvnname_2006 WHERE appno IN (l_appno, l_appno_pad);

Line: 90

             OPEN l_result FOR SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_n_cvnname_2006 WHERE appno IN (l_appno, l_appno_pad);

Line: 92

             OPEN l_result FOR  SELECT SUBSTR(LPAD(appno,9,0),1,8) FROM igs_uc_n_cvnname_2006 WHERE (UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate)) OR appno IN (l_appno, l_appno_pad);

Line: 94

             OPEN l_result FOR SELECT count(*) count1 FROM igs_uc_n_cvnname_2006 WHERE UPPER(surname) = UPPER(p_surname) AND TRUNC(BIRTHDATE) = TRUNC(p_birthdate);

Line: 123

    SELECT decision, system_code
      FROM igs_uc_transactions
     WHERE uc_tran_id = p_uc_tran_id;

Line: 176

    SELECT time_of_year, extra_start_date, last_le_date, transaction_toy_code
      FROM igs_uc_ucas_control
     WHERE system_code = p_system_code
       AND ucas_cycle = p_ucas_cycle;