APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_AD_LOCATION

Line 110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,

106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
112: p_message OUT NOCOPY VARCHAR2
113: ) IS
114: ------------------------------------------------------------------

Line 134: igs_ad_location al ,

130: SELECT uoo.unit_cd , uv.title , uoo.cal_type ,
131: ci.alternate_code , al.description location_desc ,
132: uoo.unit_class
133: FROM igs_ps_unit_ofr_opt uoo ,
134: igs_ad_location al ,
135: igs_ps_unit_ver uv ,
136: igs_ca_inst ci
137: WHERE uoo.unit_cd = uv.unit_cd
138: AND uoo.version_number = uv.version_number