APPS.IGS_AS_VAL_ESVS dependencies on IGS_AS_EXM_SES_VN_SP

Line 159: FROM IGS_AS_EXM_SES_VN_SP esvs,

155: CURSOR c_esvs_ve (
156: cp_dt_alias_val DATE,
157: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
158: SELECT 'x'
159: FROM IGS_AS_EXM_SES_VN_SP esvs,
160: IGS_GR_VENUE ve
161: WHERE esvs.person_id = p_person_id AND
162: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
163: esvs.dt_alias,

Line 262: FROM IGS_AS_EXM_SES_VN_SP esvs

258: Igs_Ge_Gen_003.GENP_SET_TIME( NVL(override_end_time, end_time)) >= v_end_time)) AND
259: venue_cd <> p_venue_cd;
260: CURSOR c_esvs IS
261: SELECT 'X'
262: FROM IGS_AS_EXM_SES_VN_SP esvs
263: WHERE person_id = p_person_id AND
264: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
265: dt_alias,
266: dai_sequence_number,