APPS.IGS_EN_SUA_API dependencies on IGS_EN_OR_UNIT_WLST_V

Line 102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v

98: -- Getting the maximum students per waitlist from organization level.
99: CURSOR c_max_std_per_wait_org (cp_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE,
100: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
101: cp_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE) IS
102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v
103: WHERE org_unit_cd = cp_org_unit_cd
104: AND cal_type = cp_cal_type
105: AND sequence_number = cp_ci_sequence_number ;
106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;

Line 106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;

102: SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst_v
103: WHERE org_unit_cd = cp_org_unit_cd
104: AND cal_type = cp_cal_type
105: AND sequence_number = cp_ci_sequence_number ;
106: l_max_std_per_wait_org igs_en_or_unit_wlst_v.max_stud_per_wlst%TYPE;
107:
108: -- end of the added three cursors. pmarada
109: -- Cursor to Check if Waitlisting is allowed at the unit section level .
110: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS