APPS.IGS_EN_SUA_API dependencies on IGS_PS_UNIT_VER

Line 70: igs_ps_unit_ver uv,

66:
67: CURSOR c_usec_lim (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
68: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,999999) ) enrollment_maximum
69: FROM igs_ps_usec_lim_wlst usec,
70: igs_ps_unit_ver uv,
71: igs_ps_unit_ofr_opt uoo
72: WHERE uoo.unit_cd = uv.unit_cd
73: AND uoo.version_number = uv.version_number
74: AND uoo.uoo_id = usec.uoo_id (+)

Line 634: CURSOR cur_mus_allwd(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,

630: FROM igs_ca_load_to_teach_v
631: WHERE load_cal_type = cp_load_cal_type
632: AND load_ci_sequence_number = cp_load_seq_num);
633:
634: CURSOR cur_mus_allwd(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
635: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
636: SELECT same_teaching_period
637: FROM igs_ps_unit_ver
638: WHERE unit_cd = cp_unit_cd

Line 635: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS

631: WHERE load_cal_type = cp_load_cal_type
632: AND load_ci_sequence_number = cp_load_seq_num);
633:
634: CURSOR cur_mus_allwd(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
635: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
636: SELECT same_teaching_period
637: FROM igs_ps_unit_ver
638: WHERE unit_cd = cp_unit_cd
639: AND version_number = cp_version_number;

Line 637: FROM igs_ps_unit_ver

633:
634: CURSOR cur_mus_allwd(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
635: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
636: SELECT same_teaching_period
637: FROM igs_ps_unit_ver
638: WHERE unit_cd = cp_unit_cd
639: AND version_number = cp_version_number;
640:
641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,

Line 675: igs_ps_unit_ver uv

671: WHERE cal_type = cp_load_cal_type AND
672: closed_flag = 'N' AND
673: org_unit_cd = (SELECT nvl(uoo.owner_org_unit_Cd, uv.owner_org_unit_cd)
674: FROM igs_ps_unit_ofr_opt uoo,
675: igs_ps_unit_ver uv
676: WHERE uoo.uoo_id = cp_uoo_id AND
677: uv.unit_cd = uoo.unit_cd AND
678: uv.version_number = uoo.version_number);
679:

Line 682: v_mus_allwd igs_ps_unit_ver.same_teaching_period%type;

678: uv.version_number = uoo.version_number);
679:
680: v_max_wlst_stud IGS_EN_INST_WL_STPS.max_waitlists_student_num%type;
681: v_count_wlst_stud NUMBER;
682: v_mus_allwd igs_ps_unit_ver.same_teaching_period%type;
683: v_simul_wlst_flag VARCHAR(1);
684: v_wlst_same_unit VARCHAR2(1);
685: v_simul_term_wlst_flag VARCHAR2(1);
686: v_simul_org_allwd VARCHAR2(1);