APPS.IGS_AS_GEN_002 dependencies on IGS_AD_LOCATION_TYPE

Line 56: igs_ad_location_type lt

52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,
55: igs_ad_location loc,
56: igs_ad_location_type lt
57: WHERE lr.location_cd = p_location_cd
58: AND NVL (lr.dflt_ind, 'N') = 'Y'
59: AND NVL (loc.closed_ind, 'N') = 'N'
60: AND lt.s_location_type = 'EXAM_CTR'