APPS.IGS_AS_VAL_VE dependencies on IGS_AD_LOCATION_TYPE

Line 23: FROM IGS_AD_LOCATION_TYPE lot,

19: -- Validate s_loc_type = EXAM_CTR or GRD_CTR
20: DECLARE
21: CURSOR c_lot IS
22: SELECT 'x'
23: FROM IGS_AD_LOCATION_TYPE lot,
24: IGS_AD_LOCATION loc
25: WHERE lot.location_type = loc.location_type AND
26: loc.location_cd = p_exam_location_cd AND
27: lot.s_location_type = 'EXAM_CTR' OR

Line 37: -- The system IGS_AD_LOCATION type must be specified as EXAM_CTR or GRD_CTR

33: OPEN c_lot;
34: FETCH c_lot INTO v_lot_exists;
35: IF (c_lot%NOTFOUND) THEN
36: CLOSE c_lot;
37: -- The system IGS_AD_LOCATION type must be specified as EXAM_CTR or GRD_CTR
38: p_message_name := 'IGS_AS_SYS_LOCTYPE_EXAM_CTR';
39: RETURN FALSE;
40: END IF;
41: CLOSE c_lot;