APPS.IGS_AS_GEN_006 dependencies on IGS_AD_LOCATION_TYPE

Line 2081: IGS_AD_LOCATION_TYPE lot

2077: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
2078: SELECT 'X'
2079: FROM IGS_AD_LOCATION_REL lr,
2080: IGS_AD_LOCATION loc,
2081: IGS_AD_LOCATION_TYPE lot
2082: WHERE lr.sub_location_cd = cp_exam_location_cd AND
2083: lr.location_cd = loc.location_cd AND
2084: loc.LOCATION_TYPE = lot.LOCATION_TYPE AND
2085: lot.s_location_type = 'CAMPUS';