APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on HZ_GEOGRAPHIES

Line 199: FROM hz_geographies hzg,

195: decode(l_qual_num, 22, geography_name, NULL) qual22_value1,
196: decode(l_qual_num, 23, geography_name, NULL) qual23_value1,
197: decode(l_qual_num, 24, geography_name, NULL) qual24_value1,
198: decode(l_qual_num, 25, geography_name, NULL) qual25_value1
199: FROM hz_geographies hzg,
200: jtf_terr_values_all qv,
201: jtf_terr_qual_all jtq
202: WHERE hzg.geography_type = l_qual_name
203: AND jtq.terr_qual_id = qv.terr_qual_id