APPS.IGS_EN_SUA_API dependencies on IGS_EN_INST_WL_STPS

Line 619: FROM IGS_EN_INST_WL_STPS;

615: --cursors to check max waitlist per student and validations for simultaneous wailists
616: --as part of wailist enhancement build , bug# 3052426.
617: CURSOR cur_max_wlst_stud IS
618: SELECT max_waitlists_student_num
619: FROM IGS_EN_INST_WL_STPS;
620:
621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,
622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS

Line 659: FROM igs_en_inst_wl_stps;

655: sua.uoo_id <> cp_uoo_id;
656:
657: CURSOR cur_simul_wlst_flag IS
658: SELECT simultaneous_wlst_alwd_flag
659: FROM igs_en_inst_wl_stps;
660:
661: CURSOR cur_simul_term_wlst_flag(p_load_cal_type IGS_CA_INST.cal_type%TYPE) IS
662: SELECT 'X'
663: FROM igs_en_inst_wlst_opt

Line 680: v_max_wlst_stud IGS_EN_INST_WL_STPS.max_waitlists_student_num%type;

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:
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);