APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_USEC_X_GRPMEM

Line 551: l_max_enr_x_grp igs_ps_usec_x_grpmem_v.enrollment_maximum%TYPE;

547: sommukhe 24-Jan-2006 Bug #4926548,modified the cursor org_unit to fetch org_unit_description
548: ***************************************************************/
549: l_ou_description igs_or_inst_org_base_v.party_name%TYPE;
550: l_usec_x_grp_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE;
551: l_max_enr_x_grp igs_ps_usec_x_grpmem_v.enrollment_maximum%TYPE;
552: l_meet_with_grp_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE;
553:
554: -- Get the Org Unit description for the unit
555: CURSOR org_unit( cp_owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE) IS

Line 578: igs_ps_usec_x_grpmem_v B

574: -- Get the Cross Listed Group Name of the uoo_id
575: CURSOR usec_x_grp_name ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
576: SELECT A.usec_x_listed_group_name
577: FROM igs_ps_usec_x_grp_v A,
578: igs_ps_usec_x_grpmem_v B
579: WHERE A.usec_x_listed_group_id = B.usec_x_listed_group_id
580: AND B.uoo_id = l_uoo_id
581: AND B.parent = 'Y';
582:

Line 590: igs_ps_usec_x_grpmem B

586:
587: CURSOR max_enr_x_grp ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
588: SELECT NVL(A.max_ovr_group, A.max_enr_group) enroll_max
589: FROM igs_ps_usec_x_grp A,
590: igs_ps_usec_x_grpmem B
591: WHERE A.max_enr_group IS NOT NULL AND
592: A.usec_x_listed_group_id = B.usec_x_listed_group_id AND
593: B.uoo_id = l_uoo_id and B.parent = 'Y'
594: UNION ALL

Line 596: FROM igs_ps_usec_x_grpmem_v A,

592: A.usec_x_listed_group_id = B.usec_x_listed_group_id AND
593: B.uoo_id = l_uoo_id and B.parent = 'Y'
594: UNION ALL
595: SELECT SUM(nvl(A.override_maximum, A.enrollment_maximum)) enroll_max
596: FROM igs_ps_usec_x_grpmem_v A,
597: igs_ps_usec_x_grpmem_v B
598: WHERE A.enrollment_maximum is NOT NULL
599: AND A.usec_x_listed_group_id = B.usec_x_listed_group_id
600: AND B.uoo_id = l_uoo_id

Line 597: igs_ps_usec_x_grpmem_v B

593: B.uoo_id = l_uoo_id and B.parent = 'Y'
594: UNION ALL
595: SELECT SUM(nvl(A.override_maximum, A.enrollment_maximum)) enroll_max
596: FROM igs_ps_usec_x_grpmem_v A,
597: igs_ps_usec_x_grpmem_v B
598: WHERE A.enrollment_maximum is NOT NULL
599: AND A.usec_x_listed_group_id = B.usec_x_listed_group_id
600: AND B.uoo_id = l_uoo_id
601: AND B.parent = 'Y';