APPS.IGS_AS_VAL_EIS dependencies on IGS_AS_EXM_SUPRVISOR

Line 84: IGS_AS_EXM_SUPRVISOR esu,

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
88: eis.exam_ci_sequence_number = p_exam_ci_sequence_number AND

Line 100: IGS_AS_EXM_SUPRVISOR esu,

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
104: esvs.exam_ci_sequence_number = p_exam_ci_sequence_number AND

Line 180: FROM IGS_AS_EXM_SUPRVISOR esu,

176: v_est_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
177: v_in_charge_ind IGS_AS_EXM_SPRVSRTYP.in_charge_ind%TYPE;
178: CURSOR c_est IS
179: SELECT est.in_charge_ind
180: FROM IGS_AS_EXM_SUPRVISOR esu,
181: IGS_AS_EXM_SPRVSRTYP est
182: WHERE esu.person_id = p_person_id AND
183: esu.exam_supervisor_type = est.exam_supervisor_type;
184: CURSOR c_est2 IS