eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TTY_GEO_TERR

Line 68: TYPE g_geo_territory_id_tab IS TABLE OF jtf_tty_geo_terr.geo_territory_id%TYPE;

64: TYPE g_change_type_tab IS TABLE OF jtf_tty_named_acct_changes.change_type%TYPE;
65: TYPE g_from_where_tab IS TABLE OF jtf_tty_named_acct_changes.from_where%TYPE;
66: TYPE g_terr_group_account_id_tab IS TABLE OF jtf_tty_terr_grp_accts.terr_group_account_id%TYPE;
67: TYPE g_terr_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
68: TYPE g_geo_territory_id_tab IS TABLE OF jtf_tty_geo_terr.geo_territory_id%TYPE;
69: TYPE g_geo_terr_name_tab IS TABLE OF jtf_tty_geo_terr.geo_terr_name%TYPE;
70: TYPE g_terr_attribute_tab IS TABLE OF jtf_tty_terr_grp_accts.attribute1%TYPE;
71: TYPE g_terr_attr_cat_tab IS TABLE OF jtf_terr_all.attribute_category%TYPE;
72: -- TYPE g_terr_created_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;

Line 69: TYPE g_geo_terr_name_tab IS TABLE OF jtf_tty_geo_terr.geo_terr_name%TYPE;

65: TYPE g_from_where_tab IS TABLE OF jtf_tty_named_acct_changes.from_where%TYPE;
66: TYPE g_terr_group_account_id_tab IS TABLE OF jtf_tty_terr_grp_accts.terr_group_account_id%TYPE;
67: TYPE g_terr_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
68: TYPE g_geo_territory_id_tab IS TABLE OF jtf_tty_geo_terr.geo_territory_id%TYPE;
69: TYPE g_geo_terr_name_tab IS TABLE OF jtf_tty_geo_terr.geo_terr_name%TYPE;
70: TYPE g_terr_attribute_tab IS TABLE OF jtf_tty_terr_grp_accts.attribute1%TYPE;
71: TYPE g_terr_attr_cat_tab IS TABLE OF jtf_terr_all.attribute_category%TYPE;
72: -- TYPE g_terr_created_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
73: -- TYPE g_terr_creation_flag_tab IS TABLE OF VARCHAR2(1);

Line 983: FROM jtf_tty_geo_terr gterr

979: /* get all the geographies for a given territory group id */
980: CURSOR geo_territories( l_terr_group_id NUMBER) IS
981: SELECT gterr.geo_territory_id
982: , gterr.geo_terr_name
983: FROM jtf_tty_geo_terr gterr
984: WHERE gterr.terr_group_id = l_terr_group_id;
985:
986: /** Transaction Types for a NON-OVERLAY territory are
987: ** determined by all salesteam members on this geography territories

Line 997: JTF_TTY_GEO_TERR_RSC grsc

993: */
994: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
995: SELECT ra.access_type
996: FROM
997: JTF_TTY_GEO_TERR_RSC grsc
998: , jtf_tty_geo_terr gtr
999: , jtf_tty_terr_grp_roles tgr
1000: , jtf_tty_role_access ra
1001: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 998: , jtf_tty_geo_terr gtr

994: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
995: SELECT ra.access_type
996: FROM
997: JTF_TTY_GEO_TERR_RSC grsc
998: , jtf_tty_geo_terr gtr
999: , jtf_tty_terr_grp_roles tgr
1000: , jtf_tty_role_access ra
1001: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
1002: AND gtr.geo_territory_id = grsc.geo_territory_id

Line 1010: JTF_TTY_GEO_TERR_RSC grsc

1006: AND ra.access_type IN ('ACCOUNT')
1007: UNION
1008: SELECT ra.access_type
1009: FROM
1010: JTF_TTY_GEO_TERR_RSC grsc
1011: , jtf_tty_geo_terr gtr
1012: , jtf_tty_terr_grp_roles tgr
1013: , jtf_tty_role_access ra
1014: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 1011: , jtf_tty_geo_terr gtr

1007: UNION
1008: SELECT ra.access_type
1009: FROM
1010: JTF_TTY_GEO_TERR_RSC grsc
1011: , jtf_tty_geo_terr gtr
1012: , jtf_tty_terr_grp_roles tgr
1013: , jtf_tty_role_access ra
1014: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
1015: AND gtr.geo_territory_id = grsc.geo_territory_id

Line 1043: jtf_tty_geo_terr terr,

1039: ,g.geo_id geo_id
1040: ,terr.geo_territory_id geo_territory_id
1041: FROM jtf_tty_geo_grp_values grpv,
1042: jtf_tty_terr_groups tg,
1043: jtf_tty_geo_terr terr,
1044: jtf_tty_geographies g --postal_code level
1045: WHERE terr.terr_group_id = tg.terr_group_id
1046: AND terr.terr_group_id = grpv.terr_group_id
1047: AND terr.owner_resource_id < 0

Line 1060: jtf_tty_geo_terr terr,

1056: ,g.geo_id geo_id
1057: ,terr.geo_territory_id geo_territory_id
1058: FROM jtf_tty_geo_grp_values grpv,
1059: jtf_tty_terr_groups tg,
1060: jtf_tty_geo_terr terr,
1061: jtf_tty_geographies g, --postal_code level
1062: jtf_tty_geographies g1,
1063: jtf_tty_geographies g2
1064: WHERE terr.terr_group_id = tg.terr_group_id

Line 1079: jtf_tty_geo_terr terr,

1075: ,g.geo_id geo_id
1076: ,terr.geo_territory_id geo_territory_id
1077: FROM jtf_tty_geo_grp_values grpv,
1078: jtf_tty_terr_groups tg,
1079: jtf_tty_geo_terr terr,
1080: jtf_tty_geographies g,
1081: jtf_tty_geographies g1
1082: WHERE terr.terr_group_id = tg.terr_group_id
1083: AND terr.terr_group_id = grpv.terr_group_id

Line 1129: jtf_tty_geo_terr terr,

1125: SELECT g.postal_code postal_code
1126: ,g.geo_id geo_id
1127: ,terr.geo_territory_id geo_territory_id
1128: FROM jtf_tty_terr_groups tg,
1129: jtf_tty_geo_terr terr,
1130: jtf_tty_geographies g,
1131: jtf_tty_geo_terr_values tv
1132: WHERE terr.terr_group_id = tg.terr_group_id
1133: AND terr.owner_resource_id >= 0

Line 1131: jtf_tty_geo_terr_values tv

1127: ,terr.geo_territory_id geo_territory_id
1128: FROM jtf_tty_terr_groups tg,
1129: jtf_tty_geo_terr terr,
1130: jtf_tty_geographies g,
1131: jtf_tty_geo_terr_values tv
1132: WHERE terr.terr_group_id = tg.terr_group_id
1133: AND terr.owner_resource_id >= 0
1134: AND terr.parent_geo_terr_id >= 0 -- not default terr
1135: AND tv.geo_territory_id = terr.geo_territory_id

Line 1141: FROM jtf_tty_geo_terr terr,

1137: ) main
1138: WHERE main.geo_id NOT IN -- the terr the user owners
1139: (
1140: SELECT tv.geo_id geo_id
1141: FROM jtf_tty_geo_terr terr,
1142: jtf_tty_geo_terr_values tv
1143: WHERE tv.geo_territory_id = terr.geo_territory_id
1144: AND main.geo_territory_id = terr.parent_geo_terr_id
1145: )

Line 1142: jtf_tty_geo_terr_values tv

1138: WHERE main.geo_id NOT IN -- the terr the user owners
1139: (
1140: SELECT tv.geo_id geo_id
1141: FROM jtf_tty_geo_terr terr,
1142: jtf_tty_geo_terr_values tv
1143: WHERE tv.geo_territory_id = terr.geo_territory_id
1144: AND main.geo_territory_id = terr.parent_geo_terr_id
1145: )
1146: AND geo_territory_id = l_geo_territory_id;

Line 1180: FROM jtf_tty_geo_terr_rsc a

1176: CURSOR terr_resource (l_geo_territory_id NUMBER,l_role VARCHAR2) IS
1177: SELECT DISTINCT a.resource_id
1178: , a.rsc_group_id
1179: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
1180: FROM jtf_tty_geo_terr_rsc a
1181: , jtf_tty_geo_terr b
1182: WHERE a.geo_territory_id = b.geo_territory_id
1183: AND b.geo_territory_id = l_geo_territory_id
1184: AND a.rsc_role_code = l_role;

Line 1181: , jtf_tty_geo_terr b

1177: SELECT DISTINCT a.resource_id
1178: , a.rsc_group_id
1179: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
1180: FROM jtf_tty_geo_terr_rsc a
1181: , jtf_tty_geo_terr b
1182: WHERE a.geo_territory_id = b.geo_territory_id
1183: AND b.geo_territory_id = l_geo_territory_id
1184: AND a.rsc_role_code = l_role;
1185:

Line 1228: FROM jtf_tty_geo_terr gterr

1224: ** used for OVERLAY territory creation */
1225: CURSOR get_OVLY_geographies(LP_terr_group_id NUMBER) IS
1226: SELECT gterr.geo_territory_id
1227: , gterr.geo_terr_name
1228: FROM jtf_tty_geo_terr gterr
1229: WHERE gterr.terr_group_id = lp_terr_group_id
1230: AND EXISTS (
1231: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
1232: SELECT NULL

Line 1233: FROM jtf_tty_geo_terr_rsc grsc

1229: WHERE gterr.terr_group_id = lp_terr_group_id
1230: AND EXISTS (
1231: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
1232: SELECT NULL
1233: FROM jtf_tty_geo_terr_rsc grsc
1234: , jtf_tty_role_prod_int rpi
1235: , jtf_tty_terr_grp_roles tgr
1236: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
1237: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 1257: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

1253: AND b.terr_group_id = lp_terr_group_id
1254: AND EXISTS (
1255: /* Named Account exists with Salesperson with this role */
1256: SELECT NULL
1257: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
1258: WHERE gterr.geo_territory_id = grsc.geo_territory_id
1259: AND grsc.geo_territory_id = lp_geo_territory_id
1260: AND gterr.terr_group_id = b.terr_group_id
1261: AND grsc.rsc_role_code = b.role_code );

Line 1394: FROM jtf_tty_geo_terr gterr

1390: /* or it must be the default geography territory */
1391: BEGIN
1392: SELECT 1
1393: INTO l_geo_count
1394: FROM jtf_tty_geo_terr gterr
1395: WHERE gterr.geo_territory_id = p_geo_territory_id(x)
1396: AND ( gterr.parent_geo_terr_id < 0
1397: OR EXISTS (
1398: SELECT 1

Line 1399: FROM jtf_tty_geo_terr_values gtval

1395: WHERE gterr.geo_territory_id = p_geo_territory_id(x)
1396: AND ( gterr.parent_geo_terr_id < 0
1397: OR EXISTS (
1398: SELECT 1
1399: FROM jtf_tty_geo_terr_values gtval
1400: WHERE gterr.geo_territory_id = gtval.geo_territory_id));
1401: EXCEPTION
1402: WHEN NO_DATA_FOUND THEN
1403: l_geo_count := 0;

Line 1782: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

1778: AND b.terr_group_id = p_TERR_GROUP_ID(x)
1779: AND EXISTS (
1780: /* Geography Territory exists with Salesperson with this role */
1781: SELECT NULL
1782: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
1783: WHERE grsc.geo_territory_id = gterr.geo_territory_id
1784: AND gterr.terr_group_id = b.terr_group_id
1785: AND grsc.rsc_role_code = b.role_code )
1786: AND ROWNUM < 2;

Line 2479: FROM jtf_tty_geo_terr gterr

2475: /* get all the geographies for a given territory group id */
2476: CURSOR geo_territories( l_terr_group_id NUMBER) IS
2477: SELECT gterr.geo_territory_id
2478: , gterr.geo_terr_name
2479: FROM jtf_tty_geo_terr gterr
2480: WHERE gterr.terr_group_id = l_terr_group_id
2481: AND ( gterr.parent_geo_terr_id < 0
2482: OR EXISTS (
2483: SELECT 1

Line 2484: FROM jtf_tty_geo_terr_values gtval

2480: WHERE gterr.terr_group_id = l_terr_group_id
2481: AND ( gterr.parent_geo_terr_id < 0
2482: OR EXISTS (
2483: SELECT 1
2484: FROM jtf_tty_geo_terr_values gtval
2485: WHERE gterr.geo_territory_id = gtval.geo_territory_id));
2486:
2487: /** Transaction Types for a NON-OVERLAY territory are
2488: ** determined by all salesteam members on this geography territories

Line 2498: JTF_TTY_GEO_TERR_RSC grsc

2494: */
2495: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
2496: SELECT ra.access_type
2497: FROM
2498: JTF_TTY_GEO_TERR_RSC grsc
2499: , jtf_tty_geo_terr gtr
2500: , jtf_tty_terr_grp_roles tgr
2501: , jtf_tty_role_access ra
2502: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 2499: , jtf_tty_geo_terr gtr

2495: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
2496: SELECT ra.access_type
2497: FROM
2498: JTF_TTY_GEO_TERR_RSC grsc
2499: , jtf_tty_geo_terr gtr
2500: , jtf_tty_terr_grp_roles tgr
2501: , jtf_tty_role_access ra
2502: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
2503: AND gtr.geo_territory_id = grsc.geo_territory_id

Line 2511: JTF_TTY_GEO_TERR_RSC grsc

2507: AND ra.access_type IN ('ACCOUNT')
2508: UNION
2509: SELECT ra.access_type
2510: FROM
2511: JTF_TTY_GEO_TERR_RSC grsc
2512: , jtf_tty_geo_terr gtr
2513: , jtf_tty_terr_grp_roles tgr
2514: , jtf_tty_role_access ra
2515: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 2512: , jtf_tty_geo_terr gtr

2508: UNION
2509: SELECT ra.access_type
2510: FROM
2511: JTF_TTY_GEO_TERR_RSC grsc
2512: , jtf_tty_geo_terr gtr
2513: , jtf_tty_terr_grp_roles tgr
2514: , jtf_tty_role_access ra
2515: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
2516: AND gtr.geo_territory_id = grsc.geo_territory_id

Line 2544: jtf_tty_geo_terr terr,

2540: ,g.geo_id geo_id
2541: ,terr.geo_territory_id geo_territory_id
2542: FROM jtf_tty_geo_grp_values grpv,
2543: jtf_tty_terr_groups tg,
2544: jtf_tty_geo_terr terr,
2545: jtf_tty_geographies g --postal_code level
2546: WHERE terr.terr_group_id = tg.terr_group_id
2547: AND terr.terr_group_id = grpv.terr_group_id
2548: AND terr.owner_resource_id < 0

Line 2561: jtf_tty_geo_terr terr,

2557: ,g.geo_id geo_id
2558: ,terr.geo_territory_id geo_territory_id
2559: FROM jtf_tty_geo_grp_values grpv,
2560: jtf_tty_terr_groups tg,
2561: jtf_tty_geo_terr terr,
2562: jtf_tty_geographies g, --postal_code level
2563: jtf_tty_geographies g1,
2564: jtf_tty_geographies g2
2565: WHERE terr.terr_group_id = tg.terr_group_id

Line 2580: jtf_tty_geo_terr terr,

2576: ,g.geo_id geo_id
2577: ,terr.geo_territory_id geo_territory_id
2578: FROM jtf_tty_geo_grp_values grpv,
2579: jtf_tty_terr_groups tg,
2580: jtf_tty_geo_terr terr,
2581: jtf_tty_geographies g,
2582: jtf_tty_geographies g1
2583: WHERE terr.terr_group_id = tg.terr_group_id
2584: AND terr.terr_group_id = grpv.terr_group_id

Line 2630: jtf_tty_geo_terr terr,

2626: SELECT g.postal_code postal_code
2627: ,g.geo_id geo_id
2628: ,terr.geo_territory_id geo_territory_id
2629: FROM jtf_tty_terr_groups tg,
2630: jtf_tty_geo_terr terr,
2631: jtf_tty_geographies g,
2632: jtf_tty_geo_terr_values tv
2633: WHERE terr.terr_group_id = tg.terr_group_id
2634: AND terr.owner_resource_id >= 0

Line 2632: jtf_tty_geo_terr_values tv

2628: ,terr.geo_territory_id geo_territory_id
2629: FROM jtf_tty_terr_groups tg,
2630: jtf_tty_geo_terr terr,
2631: jtf_tty_geographies g,
2632: jtf_tty_geo_terr_values tv
2633: WHERE terr.terr_group_id = tg.terr_group_id
2634: AND terr.owner_resource_id >= 0
2635: AND terr.parent_geo_terr_id >= 0 -- not default terr
2636: AND tv.geo_territory_id = terr.geo_territory_id

Line 2642: FROM jtf_tty_geo_terr terr,

2638: ) main
2639: WHERE main.geo_id NOT IN -- the terr the user owners
2640: (
2641: SELECT tv.geo_id geo_id
2642: FROM jtf_tty_geo_terr terr,
2643: jtf_tty_geo_terr_values tv
2644: WHERE tv.geo_territory_id = terr.geo_territory_id
2645: AND main.geo_territory_id = terr.parent_geo_terr_id
2646: )

Line 2643: jtf_tty_geo_terr_values tv

2639: WHERE main.geo_id NOT IN -- the terr the user owners
2640: (
2641: SELECT tv.geo_id geo_id
2642: FROM jtf_tty_geo_terr terr,
2643: jtf_tty_geo_terr_values tv
2644: WHERE tv.geo_territory_id = terr.geo_territory_id
2645: AND main.geo_territory_id = terr.parent_geo_terr_id
2646: )
2647: AND geo_territory_id = l_geo_territory_id;

Line 2681: FROM jtf_tty_geo_terr_rsc a

2677: CURSOR terr_resource (l_geo_territory_id NUMBER,l_role VARCHAR2) IS
2678: SELECT DISTINCT a.resource_id
2679: , a.rsc_group_id
2680: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
2681: FROM jtf_tty_geo_terr_rsc a
2682: , jtf_tty_geo_terr b
2683: WHERE a.geo_territory_id = b.geo_territory_id
2684: AND b.geo_territory_id = l_geo_territory_id
2685: AND a.rsc_role_code = l_role;

Line 2682: , jtf_tty_geo_terr b

2678: SELECT DISTINCT a.resource_id
2679: , a.rsc_group_id
2680: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
2681: FROM jtf_tty_geo_terr_rsc a
2682: , jtf_tty_geo_terr b
2683: WHERE a.geo_territory_id = b.geo_territory_id
2684: AND b.geo_territory_id = l_geo_territory_id
2685: AND a.rsc_role_code = l_role;
2686:

Line 2729: FROM jtf_tty_geo_terr gterr

2725: ** used for OVERLAY territory creation */
2726: CURSOR get_OVLY_geographies(LP_terr_group_id NUMBER) IS
2727: SELECT gterr.geo_territory_id
2728: , gterr.geo_terr_name
2729: FROM jtf_tty_geo_terr gterr
2730: WHERE gterr.terr_group_id = lp_terr_group_id
2731: AND EXISTS (
2732: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
2733: SELECT NULL

Line 2734: FROM jtf_tty_geo_terr_rsc grsc

2730: WHERE gterr.terr_group_id = lp_terr_group_id
2731: AND EXISTS (
2732: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
2733: SELECT NULL
2734: FROM jtf_tty_geo_terr_rsc grsc
2735: , jtf_tty_role_prod_int rpi
2736: , jtf_tty_terr_grp_roles tgr
2737: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
2738: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 2758: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

2754: AND b.terr_group_id = lp_terr_group_id
2755: AND EXISTS (
2756: /* Named Account exists with Salesperson with this role */
2757: SELECT NULL
2758: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
2759: WHERE gterr.geo_territory_id = grsc.geo_territory_id
2760: AND grsc.geo_territory_id = lp_geo_territory_id
2761: AND gterr.terr_group_id = b.terr_group_id
2762: AND grsc.rsc_role_code = b.role_code );

Line 3448: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

3444: AND b.terr_group_id = p_TERR_GROUP_ID(x)
3445: AND EXISTS (
3446: /* Geography territory exists with Salesperson with this role */
3447: SELECT NULL
3448: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
3449: WHERE grsc.geo_territory_id = gterr.geo_territory_id
3450: AND gterr.terr_group_id = b.terr_group_id
3451: AND grsc.rsc_role_code = b.role_code )
3452: AND ROWNUM < 2;

Line 10394: FROM jtf_tty_geo_terr B

10390: ,C.last_update_login
10391: ,D.org_id
10392: ,-1 * B.terr_group_id
10393: ,E.terr_id
10394: FROM jtf_tty_geo_terr B
10395: ,jtf_tty_terr_groups C
10396: ,jtf_terr_all D
10397: ,jtf_terr_all E -- to get the terr_id of the top level territory of overlay branch
10398: WHERE B.geo_territory_id = l_geo_territory_id

Line 10585: FROM jtf_tty_geo_terr B

10581: ,C.last_update_login
10582: ,D.org_id
10583: ,-1 * B.terr_group_id
10584: ,E.terr_id
10585: FROM jtf_tty_geo_terr B
10586: ,jtf_tty_terr_groups C
10587: ,jtf_terr_all D
10588: ,jtf_terr_all E -- to get the terr_id of the top level territory of overlay branch
10589: WHERE B.geo_territory_id = l_geo_terr_id

Line 10599: FROM JTF_TTY_GEO_TERR

10595:
10596: /* All the child territories of the territories that have been updated */
10597: CURSOR child_terr(l_geo_terr_id NUMBER) IS
10598: SELECT geo_territory_id
10599: FROM JTF_TTY_GEO_TERR
10600: WHERE geo_territory_id <> l_geo_terr_id
10601: START WITH geo_territory_id = l_geo_terr_id
10602: CONNECT BY PRIOR geo_territory_id = parent_geo_terr_id;
10603:

Line 10696: FROM jtf_tty_geo_terr A

10692: BEGIN
10693: /* Get the parent territory id and recreate it */
10694: SELECT A.parent_geo_terr_id
10695: INTO l_parent_geo_terr_id
10696: FROM jtf_tty_geo_terr A
10697: WHERE A.geo_territory_id = l_geo_territory_id(i);
10698:
10699: IF G_Debug THEN
10700: Write_Log(2, 'Start : process_parent_geo_terr');