APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_GEO_TERR

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))

Line 2346: UPDATE JTF_TTY_GEO_TERR

2342: NUM_WINNERS = p_num_winners,
2343: GENERATE_CATCHALL_FLAG = p_generate_na_flag
2344: WHERE TERR_GROUP_ID = p_terr_gp_id;
2345: IF (p_group_type = 'GEOGRAPHY') THEN
2346: UPDATE JTF_TTY_GEO_TERR
2347: SET GEO_TERR_NAME = p_terr_gp_name
2348: WHERE TERR_GROUP_ID = p_terr_gp_id
2349: AND OWNER_RESOURCE_ID = -999
2350: AND GEO_TERRITORY_ID = - PARENT_GEO_TERR_ID;