APPS.IGS_AS_VAL_ELS dependencies on IGS_AD_LOCATION_TYPE

Line 22: FROM IGS_AD_LOCATION_TYPE lot,

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