APPS.IGS_AS_VAL_EIS dependencies on IGS_AS_EXM_INS_SPVSR

Line 83: FROM IGS_AS_EXM_INS_SPVSR eis,

79: in_charge_ind = 'N';
80: v_not_charge_exist VARCHAR2(1);
81: CURSOR c_exam_inst_count IS
82: SELECT count(distinct eis.person_id)
83: FROM IGS_AS_EXM_INS_SPVSR eis,
84: IGS_AS_EXM_SUPRVISOR esu,
85: IGS_AS_EXM_SPRVSRTYP est
86: WHERE eis.person_id <> p_person_id AND
87: eis.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 249: FROM IGS_AS_EXM_INS_SPVSR

245: CURSOR c_sprvsr_cnt (
246: cp_start_time IGS_AS_EXAM_SESSION.start_time%TYPE,
247: cp_end_time IGS_AS_EXAM_SESSION.end_time%TYPE) IS
248: SELECT COUNT(DISTINCT person_id)
249: FROM IGS_AS_EXM_INS_SPVSR
250: WHERE exam_cal_type = p_exam_cal_type AND
251: exam_ci_sequence_number = p_exam_ci_sequence_number AND
252: dt_alias = p_dt_alias AND
253: dai_sequence_number = p_dai_sequence_number AND