APPS.IGS_EN_SUA_API dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 184: FROM igs_ps_unit_ofr_opt_all uoo,

180: CURSOR c_meet_with_cls_details(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
181: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
182: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
183: SELECT uoo.rowid, uoo.*
184: FROM igs_ps_unit_ofr_opt_all uoo,
185: igs_ps_uso_clas_meet ucls
186: WHERE uoo.uoo_id = ucls.uoo_id
187: AND ucls.uoo_id <> l_uoo_id
188: AND ucls.class_meet_group_id = l_class_meet_group_id

Line 202: l_dir_enr igs_ps_unit_ofr_opt_all.dir_enrollment%TYPE;

198: l_usec_partof_group BOOLEAN;
199: v_grp_max igs_ps_usec_x_grp.max_enr_group%TYPE;
200: v_grp_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
201: l_setup_found NUMBER;
202: l_dir_enr igs_ps_unit_ofr_opt_all.dir_enrollment%TYPE;
203: l_enr_from_wlst igs_ps_unit_ofr_opt_all.enr_from_wlst%TYPE ;
204:
205: BEGIN
206: -- In this procedure the enrollment maximum and waitlist maximum are passed

Line 203: l_enr_from_wlst igs_ps_unit_ofr_opt_all.enr_from_wlst%TYPE ;

199: v_grp_max igs_ps_usec_x_grp.max_enr_group%TYPE;
200: v_grp_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
201: l_setup_found NUMBER;
202: l_dir_enr igs_ps_unit_ofr_opt_all.dir_enrollment%TYPE;
203: l_enr_from_wlst igs_ps_unit_ofr_opt_all.enr_from_wlst%TYPE ;
204:
205: BEGIN
206: -- In this procedure the enrollment maximum and waitlist maximum are passed
207: -- throught the usec_row record ( after updating the record itself with the