APPS.IGS_UC_EXPORT_UCAS_PKG SQL Statements

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

Line: 31

                         longer supported by UCAS as updateable views.
   pmarada  03-Jul-03    Modified as per the UCFD203 build. bug 2669208

   (reverse chronological order - newest change first)
   ********************************************************************************/
    CURSOR cur_cycle IS
    SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
    FROM igs_uc_defaults ;

Line: 43

    SELECT TO_NUMBER(LPAD(entry_year,4,200))
    FROM igs_uc_ucas_control
    WHERE system_code = cp_system_code
    AND ucas_cycle = cur_cycle_rec.configured_cycle;

Line: 52

    SELECT ucas_interface FROM  igs_uc_cyc_defaults
    WHERE ucas_cycle = cur_cycle_rec.configured_cycle
    AND system_code = cp_system_code;