APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_USO_CM_GRP

Line 552: l_meet_with_grp_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE;

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
556: SELECT party_name org_unit_description

Line 621: FROM igs_ps_uso_cm_grp A,

617: -- Get the Class Meet Group Name of the usec_id
618: -- Modified the cursor to select group name from tables rather than view as a part of Enh Bug # 2613933
619: CURSOR meet_with_grp_name ( l_uoo_id igs_ps_uso_clas_meet.uoo_id%TYPE) IS
620: SELECT A.class_meet_group_name
621: FROM igs_ps_uso_cm_grp A,
622: igs_ps_uso_clas_meet B
623: WHERE A.class_meet_group_id = B.class_meet_group_id AND
624: B.uoo_id = l_uoo_id AND
625: B.host = 'Y';

Line 632: FROM igs_ps_uso_cm_grp A,

628: -- Modified the cursor to select Enrollment Maximum when it is defined at group level(Meet With Class)
629: -- otherwise from the unit section level as a part of Enh Bug # 2613933
630: CURSOR max_enr_meet_grp ( l_uoo_id igs_ps_uso_clas_meet.uoo_id%TYPE) IS
631: SELECT NVL(A.max_ovr_group, A.max_enr_group) enroll_max
632: FROM igs_ps_uso_cm_grp A,
633: igs_ps_uso_clas_meet B
634: WHERE A.max_enr_group IS NOT NULL AND
635: A.class_meet_group_id = B.class_meet_group_id AND
636: B.uoo_id = l_uoo_id and B.host = 'Y'