APPS.IGS_AS_VAL_EIS dependencies on IGS_AS_EXM_SES_VN_SP

Line 99: FROM IGS_AS_EXM_SES_VN_SP esvs,

95: esu.exam_supervisor_type = est.exam_supervisor_type AND
96: est.in_charge_ind = 'Y';
97: CURSOR c_venue_count IS
98: SELECT count(esvs.person_id)
99: FROM IGS_AS_EXM_SES_VN_SP esvs,
100: IGS_AS_EXM_SUPRVISOR esu,
101: IGS_AS_EXM_SPRVSRTYP est
102: WHERE esvs.person_id <> p_person_id AND
103: esvs.exam_cal_type = p_exam_cal_type AND

Line 172: -- IGS_AS_EXM_INS_SPVSR or IGS_AS_EXM_SES_VN_SP. If the person is being

168:
169: BEGIN --assp_val_est_inchrg
170: --Validate the Exam Supervisor Type in-charge indicator. This routine will be
171: -- called when overiding the exam supervisor type for an
172: -- IGS_AS_EXM_INS_SPVSR or IGS_AS_EXM_SES_VN_SP. If the person is being
173: -- made an in-charge supervisor when they are normally are not in-charge,
174: -- then return a warning message.
175: DECLARE
176: v_est_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;

Line 261: FROM IGS_AS_EXM_SES_VN_SP

257: CURSOR c_venue_cnt (
258: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
259: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS
260: SELECT COUNT(person_id) -- v_venue_count
261: FROM IGS_AS_EXM_SES_VN_SP
262: WHERE exam_cal_type = p_exam_cal_type AND
263: exam_ci_sequence_number = p_exam_ci_sequence_number AND
264: dt_alias = p_dt_alias AND
265: dai_sequence_number = p_dai_sequence_number AND