APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USO_CLAS_MEET

Line 1836: FROM igs_ps_uso_clas_meet ucm,

1832:
1833: -- Cursor to get the enrollment maximum in Meet with class group
1834: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1835: SELECT grp.class_meet_group_name
1836: FROM igs_ps_uso_clas_meet ucm,
1837: igs_ps_uso_cm_grp grp
1838: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
1839: AND ucm.uoo_id = l_uoo_id;
1840:

Line 1933: FROM igs_ps_uso_clas_meet ucm,

1929:
1930: -- Cursor to get the enrollment maximum in Meet with class group
1931: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1932: SELECT grp.max_enr_group, ucm.class_meet_group_id
1933: FROM igs_ps_uso_clas_meet ucm,
1934: igs_ps_uso_cm_grp grp
1935: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
1936: AND ucm.uoo_id = l_uoo_id;
1937:

Line 1950: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS

1946:
1947:
1948: -- Cursor to get the actual enrollment of all the unit sections that belong
1949: -- to this meet with class group.
1950: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
1951: SELECT SUM(enrollment_actual)
1952: FROM igs_ps_unit_ofr_opt uoo,
1953: igs_ps_uso_clas_meet ucls
1954: WHERE uoo.uoo_id = ucls.uoo_id

Line 1953: igs_ps_uso_clas_meet ucls

1949: -- to this meet with class group.
1950: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
1951: SELECT SUM(enrollment_actual)
1952: FROM igs_ps_unit_ofr_opt uoo,
1953: igs_ps_uso_clas_meet ucls
1954: WHERE uoo.uoo_id = ucls.uoo_id
1955: AND ucls.class_meet_group_id = l_class_meet_group_id;
1956:
1957:

Line 1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;

1984: FROM igs_ps_unit_ofr_opt
1985: WHERE uoo_id = cp_uoo_id;
1986:
1987:
1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;
1989: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
1990: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
1991: l_total_enrollment NUMBER;
1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;

Line 2162: FROM igs_ps_uso_clas_meet ucm,

2158:
2159: -- Cursor to get the enrollment maximum in Meet with class group
2160: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2161: SELECT grp.max_enr_group, ucm.class_meet_group_id
2162: FROM igs_ps_uso_clas_meet ucm,
2163: igs_ps_uso_cm_grp grp
2164: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
2165: AND ucm.uoo_id = l_uoo_id;
2166:

Line 3928: FROM igs_ps_uso_clas_meet ucm,

3924:
3925: -- Cursor to get the enrollment maximum in Meet with class group
3926: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3927: SELECT grp.max_enr_group, ucm.class_meet_group_id
3928: FROM igs_ps_uso_clas_meet ucm,
3929: igs_ps_uso_cm_grp grp
3930: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
3931: AND ucm.uoo_id = l_uoo_id;
3932:

Line 3945: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS

3941:
3942:
3943: -- Cursor to get the actual enrollment of all the unit sections that belong
3944: -- to this meet with class group.
3945: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
3946: SELECT SUM(enrollment_actual)
3947: FROM igs_ps_unit_ofr_opt uoo,
3948: igs_ps_uso_clas_meet ucls
3949: WHERE uoo.uoo_id = ucls.uoo_id

Line 3948: igs_ps_uso_clas_meet ucls

3944: -- to this meet with class group.
3945: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
3946: SELECT SUM(enrollment_actual)
3947: FROM igs_ps_unit_ofr_opt uoo,
3948: igs_ps_uso_clas_meet ucls
3949: WHERE uoo.uoo_id = ucls.uoo_id
3950: AND ucls.class_meet_group_id = l_class_meet_group_id;
3951:
3952: