APPS.IGS_EN_ENROLL_WLST dependencies on IGS_EN_INST_WL_STPS

Line 806: FROM IGS_EN_INST_WL_STPS;

802: uv.unit_cd = uoo.unit_cd AND
803: uv.version_number = uoo.version_number);
804: CURSOR c_incl_inst_wlst_cp is
805: SELECT include_waitlist_cp_flag
806: FROM IGS_EN_INST_WL_STPS;
807: l_incl_wlst VARCHAR2(2);
808: BEGIN
809:
810: p_message_name := null;

Line 1741: FROM igs_en_inst_wl_stps;

1737: -- Cursor to Check if Waitlisting is allowed at the institution level. Enh Bug# 3052426 (ptandon)
1738: --
1739: CURSOR c_wait_allow_inst_level IS
1740: SELECT waitlist_allowed_flag
1741: FROM igs_en_inst_wl_stps;
1742:
1743: --
1744: -- Cursor to Check if Waitlisting is allowed at the term calendar level. Enh Bug# 3052426 (ptandon)
1745: --

Line 1751: l_waitlist_allowed igs_en_inst_wl_stps.waitlist_allowed_flag%TYPE;

1747: SELECT waitlist_alwd
1748: FROM igs_en_inst_wlst_opt
1749: WHERE cal_type = cp_load_cal_type;
1750:
1751: l_waitlist_allowed igs_en_inst_wl_stps.waitlist_allowed_flag%TYPE;
1752: lv_success_yn VARCHAR2(1);
1753:
1754: -- Routine to send mails
1755: PROCEDURE wf_send_mail_stud_adm (p_tab_succ_mail IN tab_succ_mail,