APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on HZ_GEOGRAPHIES

Line 206: FROM hz_geographies hzg,

202: decode(l_qual_num, 22, geography_name, NULL) qual22_value1,
203: decode(l_qual_num, 23, geography_name, NULL) qual23_value1,
204: decode(l_qual_num, 24, geography_name, NULL) qual24_value1,
205: decode(l_qual_num, 25, geography_name, NULL) qual25_value1
206: FROM hz_geographies hzg,
207: jtf_terr_values_all qv,
208: jtf_terr_qual_all jtq
209: WHERE hzg.geography_type = l_qual_name
210: AND jtq.terr_qual_id = qv.terr_qual_id