APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USO_CM_GRP

Line 1837: igs_ps_uso_cm_grp grp

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:
1841: -- Cursor to get the meaning for the lookup_code 'CROSS_LIST' / 'MEET_WITH'

Line 1934: igs_ps_uso_cm_grp grp

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:
1938: -- Cursor to get the actual enrollment of all the unit sections that belong

Line 2163: igs_ps_uso_cm_grp grp

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:
2167:

Line 3929: igs_ps_uso_cm_grp grp

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:
3933: -- Cursor to get the actual enrollment of all the unit sections that belong