APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_GEO_TERR_RSC

Line 1786: FROM jtf_tty_geo_terr_rsc gt, jtf_tty_geo_terr gterr, jtf_tty_terr_groups tg

1782: AND a.group_id = p_group_id;
1783:
1784: CURSOR num_geos_c IS
1785: SELECT COUNT(gt.geo_territory_id) geo
1786: FROM jtf_tty_geo_terr_rsc gt, jtf_tty_geo_terr gterr, jtf_tty_terr_groups tg
1787: WHERE gt.geo_territory_id = gterr.geo_territory_id
1788: AND tg.terr_group_id = gterr.terr_group_id
1789: AND TRUNC(tg.active_from_date) <= TRUNC(SYSDATE)
1790: AND (tg.active_to_date IS NULL OR TRUNC(tg.active_to_date) >= TRUNC(SYSDATE))