APPS.JTF_TERR_CHANGES_REPORT_PVT dependencies on JTF_TERR_OVERVIEW_V

Line 49: from jtf_terr_overview_v

45: cursor cur_territory(c_from_date date, c_to_date date) is
46: select terr_id, wf_notification.substitutespecialchars(name) name,
47: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
48: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
49: from jtf_terr_overview_v
50: where last_update_date >= c_from_date --'01-OCT-2001'
51: and last_update_date <= c_to_date; --'11-JUN-1997'
52: /* -- cursor to get salesreps DEVELOPMENT
53: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS

Line 351: from jtf_terr_overview_v

347: cursor cur_territory(c_from_date date, c_to_date date) is
348: select terr_id, wf_notification.substitutespecialchars(name) name,
349: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
350: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
351: from jtf_terr_overview_v
352: where last_update_date >= c_from_date --'01-OCT-2001'
353: and last_update_date <= c_to_date; --'11-JUN-1997'
354:
355: -- cursor to get salesreps DELIVERY