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.

APPS.IGS_EN_GEN_015 dependencies on IGS_PS_USEC_X_GRPMEM

Line 719: FROM igs_ps_usec_x_grpmem grpmem,

715:
716: -- Cursor to get the enrollment maximum in cross listed group
717: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
718: SELECT grp.max_enr_group, grp.max_ovr_group, grpmem.usec_x_listed_group_id
719: FROM igs_ps_usec_x_grpmem grpmem,
720: igs_ps_usec_x_grp grp
721: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
722: AND grpmem.uoo_id = l_uoo_id;
723:

Line 736: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

732:
733:
734: -- Cursor to get the actual enrollment of all the unit sections that belong
735: -- to this class listed group.
736: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
737: SELECT SUM(enrollment_actual)
738: FROM igs_ps_unit_ofr_opt uoo,
739: igs_ps_usec_x_grpmem ugrp
740: WHERE uoo.uoo_id = ugrp.uoo_id

Line 739: igs_ps_usec_x_grpmem ugrp

735: -- to this class listed group.
736: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
737: SELECT SUM(enrollment_actual)
738: FROM igs_ps_unit_ofr_opt uoo,
739: igs_ps_usec_x_grpmem ugrp
740: WHERE uoo.uoo_id = ugrp.uoo_id
741: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
742:
743: