APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TTY_GEO_TERR

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 50: , jtf_tty_geo_terr gtr

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
54: AND gtr.geo_territory_id = grsc.geo_territory_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;

Line 75: , jtf_tty_geo_terr b

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;
79:

Line 202: FROM jtf_tty_geo_terr

198:
199: BEGIN
200: SELECT terr_group_id
201: INTO l_geo_terr_group_id
202: FROM jtf_tty_geo_terr
203: where geo_territory_id = p_geo_terr_id;
204: --dbms_output.put_line('terr_group_id:'||l_geo_terr_group_id);
205:
206: EXCEPTION

Line 268: FROM jtf_tty_geo_terr

264: , p_geo_terr_id
265: , l_geo_terr_group_id
266: , l_start_date_active --TODO END_DATE_ACTIVE
267: , l_end_date_active
268: FROM jtf_tty_geo_terr
269: where geo_territory_id = p_geo_terr_id;
270: --dbms_output.put_line(' After inserting jtf_terr_all');
271:
272:

Line 309: from jtf_tty_geo_terr

305: , LAST_UPDATE_LOGIN
306: , l_terr_id
307: , -1001 -- FOR SALES ??
308: , l_org_id
309: from jtf_tty_geo_terr
310: where geo_territory_id = p_geo_terr_id;
311:
312: --dbms_output.put_line(' After inserting jtf_terr_usgs_all');
313:

Line 381: FROM jtf_tty_geo_terr

377: , LAST_UPDATE_LOGIN
378: , l_terr_id
379: , l_qual_type_usg_id
380: , l_org_id
381: FROM jtf_tty_geo_terr
382: WHERE geo_territory_id = p_geo_terr_id;
383:
384: --dbms_output.put_line(' After inserting jtf_terr_qtype_usgs_all');
385:

Line 448: FROM jtf_tty_geo_terr

444: , l_start_date_active
445: , l_end_date_active
446: , l_org_id --org id
447: , 1
448: FROM jtf_tty_geo_terr
449: WHERE geo_territory_id = p_geo_terr_id;
450:
451: --dbms_output.put_line(' After inserting jtf_terr_rsc_all');
452: