APPS.IGS_UC_TRX_GEN_HOOK SQL Statements

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

Line: 53

     SELECT MAX(ucas_cycle) FROM igs_uc_app_choices
       WHERE  app_no = cp_app_no
       AND    choice_no = cp_choice_no;

Line: 63

      SELECT decision, reply , ucas_program_code, campus
      FROM   igs_uc_app_choices
      WHERE  app_no= cp_app_no
        AND  choice_no = cp_choice_no
        AND  ucas_cycle = cp_ucas_cycle;

Line: 71

    SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;

Line: 76

     SELECT clearing_flag FROM igs_uc_cyc_defaults
     WHERE system_code = cp_system_code
       AND ucas_cycle = cp_ucas_cycle;

Line: 83

      SELECT 'X'
      FROM igs_uc_app_clearing
      WHERE app_no = cp_app_no;

Line: 91

      SELECT 'X'
      FROM igs_uc_app_clr_rnd
      WHERE app_no = cp_app_no;

Line: 98

    SELECT decision_code
    FROM igs_uc_map_out_stat
    WHERE system_code = p_system_code AND
          adm_outcome_status = p_adm_outcome_status AND
          closed_ind = 'N';

Line: 106

      SELECT name
      FROM igs_uc_defaults
      WHERE system_code = p_system_code;