APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TTY_GEO_TERR_RSC

Line 49: JTF_TTY_GEO_TERR_RSC grsc

45:
46: CURSOR c_get_qtype_usgs(l_geo_terr_id NUMBER) IS
47: SELECT ra.access_type
48: FROM
49: JTF_TTY_GEO_TERR_RSC grsc
50: , jtf_tty_geo_terr gtr
51: , jtf_tty_terr_grp_roles tgr
52: , jtf_tty_role_access ra
53: WHERE grsc.GEO_TERRITORY_ID = l_geo_terr_id

Line 74: FROM jtf_tty_geo_terr_rsc a

70: CURSOR c_terr_resource (l_geo_territory_id NUMBER,l_role VARCHAR2) IS
71: SELECT DISTINCT a.resource_id
72: , a.rsc_group_id
73: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
74: FROM jtf_tty_geo_terr_rsc a
75: , jtf_tty_geo_terr b
76: WHERE a.geo_territory_id = b.geo_territory_id
77: AND b.geo_territory_id = l_geo_territory_id
78: AND a.rsc_role_code = l_role;