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_SUA_API dependencies on IGS_PS_USEC_X_GRPMEM

Line 128: FROM igs_ps_usec_x_grpmem grpmem,

124:
125: -- Cursor to check whether the unit section belongs to any cross listed group or not.
126: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
127: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
128: FROM igs_ps_usec_x_grpmem grpmem,
129: igs_ps_usec_x_grp grp
130: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
131: AND grpmem.uoo_id = l_uoo_id;
132:

Line 145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

141:
142: -- Cursor to get the Actual enrollment of all the unit sections that
143: -- belong to the class listed group.
144: CURSOR c_actual_enr_crs_lst(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
146: SELECT SUM(enrollment_actual)
147: FROM igs_ps_unit_ofr_opt uoo,
148: igs_ps_usec_x_grpmem ugrp
149: WHERE uoo.uoo_id = ugrp.uoo_id

Line 148: igs_ps_usec_x_grpmem ugrp

144: CURSOR c_actual_enr_crs_lst(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
145: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
146: SELECT SUM(enrollment_actual)
147: FROM igs_ps_unit_ofr_opt uoo,
148: igs_ps_usec_x_grpmem ugrp
149: WHERE uoo.uoo_id = ugrp.uoo_id
150: AND ugrp.uoo_id <> l_uoo_id
151: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
152:

Line 168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,

164:
165:
166: -- Cursor to get the unit section details that belongs to the cross listed group.
167: CURSOR c_cross_lst_details(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
169: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
170: SELECT uoo.rowid, uoo.*
171: FROM igs_ps_unit_ofr_opt uoo,
172: igs_ps_usec_x_grpmem ugrp

Line 172: igs_ps_usec_x_grpmem ugrp

168: l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
169: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
170: SELECT uoo.rowid, uoo.*
171: FROM igs_ps_unit_ofr_opt uoo,
172: igs_ps_usec_x_grpmem ugrp
173: WHERE uoo.uoo_id = ugrp.uoo_id
174: AND ugrp.uoo_id <> l_uoo_id
175: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id
176: AND uoo.unit_section_status <> l_unit_section_status;