eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_UCRSVOP_INTS

Line 1540: FROM igs_uc_crse_dets a, igs_uc_ucrsvop_ints b

1536: -- Those records which are present in uvcoursevacoptions)
1537: CURSOR crse_vacops_cur IS
1538: SELECT a.ROWID row_id,
1539: a.*
1540: FROM igs_uc_crse_dets a, igs_uc_ucrsvop_ints b
1541: WHERE a.ucas_program_code = b.course
1542: AND a.ucas_campus = b.campus
1543: AND a.institute = g_crnt_institute
1544: AND a.system_code = 'U'

Line 1775: -- course vacancies options are available in uvcoursevacoptions table i.e. igs_uc_ucrsvop_ints

1771:
1772:
1773: -- for updating of Course vacancy information
1774: -- Update Course records to set CLEARING_OPTIONS column value to 'Y' if the corresponding
1775: -- course vacancies options are available in uvcoursevacoptions table i.e. igs_uc_ucrsvop_ints
1776: FOR crse_vacops_rec IN crse_vacops_cur
1777: LOOP
1778:
1779: BEGIN