APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_TERR_VALUES_ALL

Line 207: jtf_terr_values_all qv,

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
211: AND qv.low_value_char IN(geography_element1_code, geography_element2_code, geography_element3_code, geography_element4_code, geography_element5_code)

Line 216: FROM jtf_terr_values_all qv,

212: AND jtq.org_id = p_org_id
213: AND jtq.terr_id = p_terr_id
214: AND NOT EXISTS
215: (SELECT 1
216: FROM jtf_terr_values_all qv,
217: jtf_terr_qual_all jtq,
218: jtf_terr_all terr
219: WHERE hzg.geography_name = qv.low_value_char
220: AND jtq.terr_qual_id = qv.terr_qual_id

Line 1181: jtf_terr_values_all jtva,

1177: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
1178: qgt.display_sql2, jtva.currency_code, NULL), NULL) qual_value3,
1179: NULL qual_value4
1180: FROM jty_webadi_qual_header qgt,
1181: jtf_terr_values_all jtva,
1182: jtf_terr_qual_all jtq
1183: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1184: AND jtq.terr_qual_id = jtva.terr_qual_id --AND qgt.qualifier_num = 1
1185: AND jtq.org_id = p_org_id