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_NA_TERRGP dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 248: DELETE from JTF_TTY_TERR_GRP_ACCTS j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);

244: DELETE from jtf_tty_named_acct_rsc j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);
245:
246: -- Delete Terr Group Accounts
247: FORALL idx in l_grpAcctId_tbl.FIRST .. l_grpAcctId_tbl.LAST
248: DELETE from JTF_TTY_TERR_GRP_ACCTS j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);
249:
250: -- Delete Named Accounts
251: FORALL idx in l_acctId_tbl.FIRST .. l_acctId_tbl.LAST
252: DELETE from JTF_TTY_NAMED_ACCTS A

Line 256: FROM JTF_TTY_TERR_GRP_ACCTS tga

252: DELETE from JTF_TTY_NAMED_ACCTS A
253: WHERE A.named_account_id = l_acctId_tbl(idx)
254: AND NOT EXISTS
255: (SELECT 'Y'
256: FROM JTF_TTY_TERR_GRP_ACCTS tga
257: WHERE tga.named_account_id = A.named_account_id);
258:
259: -- Delete Named Account Qual Maps
260: FORALL idx in l_acctId_tbl.FIRST .. l_acctId_tbl.LAST

Line 333: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1

329: /* delete from the named acct sum only for affect resources */
330: /*
331: DELETE from jtf_tty_rsc_acct_summ j
332: WHERE j.RESOURCE_ID in (SELECT RESOURCE_ID
333: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1
334: WHERE j.TERR_GROUP_ACCOUNT_ID = tga1.TERR_GROUP_ACCOUNT_ID
335: AND tga1.TERR_GROUP_ID = p_terr_gp_id)
336: AND j.RSC_GROUP_ID in (SELECT RSC_GROUP_ID
337: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga2

Line 337: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga2

333: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1
334: WHERE j.TERR_GROUP_ACCOUNT_ID = tga1.TERR_GROUP_ACCOUNT_ID
335: AND tga1.TERR_GROUP_ID = p_terr_gp_id)
336: AND j.RSC_GROUP_ID in (SELECT RSC_GROUP_ID
337: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga2
338: WHERE j.TERR_GROUP_ACCOUNT_ID = tga2.TERR_GROUP_ACCOUNT_ID
339: AND tga2.TERR_GROUP_ID = p_terr_gp_id);
340: */
341: /* sum the rsc acct sum table for the deletes resources only */

Line 374: jtf_tty_terr_grp_accts tga

370: 'RS_EMPLOYEE',
371: na.site_type_code,
372: count(na.NAMED_ACCOUNT_ID) num_accts
373: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
374: jtf_tty_terr_grp_accts tga
375: where na.named_account_id = tga.named_account_id
376: and narsc.resource_id in
377: (SELECT RESOURCE_ID
378: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1

Line 378: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1

374: jtf_tty_terr_grp_accts tga
375: where na.named_account_id = tga.named_account_id
376: and narsc.resource_id in
377: (SELECT RESOURCE_ID
378: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga1
379: WHERE j.TERR_GROUP_ACCOUNT_ID = tga1.TERR_GROUP_ACCOUNT_ID
380: AND tga1.TERR_GROUP_ID = p_terr_gp_id)
381: and narsc.rsc_group_id in
382: (SELECT rsc_group_id

Line 383: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga2

379: WHERE j.TERR_GROUP_ACCOUNT_ID = tga1.TERR_GROUP_ACCOUNT_ID
380: AND tga1.TERR_GROUP_ID = p_terr_gp_id)
381: and narsc.rsc_group_id in
382: (SELECT rsc_group_id
383: from jtf_tty_acct_rsc_dn j, jtf_tty_terr_grp_accts tga2
384: WHERE j.TERR_GROUP_ACCOUNT_ID = tga2.TERR_GROUP_ACCOUNT_ID
385: AND tga2.TERR_GROUP_ID = p_terr_gp_id)
386: and tga.terr_group_id <> p_terr_gp_id
387: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID

Line 395: FROM JTF_TTY_TERR_GRP_ACCTS

391:
392: DELETE FROM jtf_tty_named_acct_rsc j
393: WHERE j.TERR_GROUP_ACCOUNT_ID IN
394: (SELECT TERR_GROUP_ACCOUNT_ID
395: FROM JTF_TTY_TERR_GRP_ACCTS
396: WHERE TERR_GROUP_ID = p_terr_gp_id);
397: /*
398: DELETE from jtf_tty_acct_rsc_dn j
399: WHERE j.TERR_GROUP_ACCOUNT_ID in

Line 401: FROM JTF_TTY_TERR_GRP_ACCTS

397: /*
398: DELETE from jtf_tty_acct_rsc_dn j
399: WHERE j.TERR_GROUP_ACCOUNT_ID in
400: (SELECT TERR_GROUP_ACCOUNT_ID
401: FROM JTF_TTY_TERR_GRP_ACCTS
402: WHERE TERR_GROUP_ID = p_terr_gp_id);
403: */
404:
405: DELETE FROM JTF_TTY_TERR_GRP_ACCTS

Line 405: DELETE FROM JTF_TTY_TERR_GRP_ACCTS

401: FROM JTF_TTY_TERR_GRP_ACCTS
402: WHERE TERR_GROUP_ID = p_terr_gp_id);
403: */
404:
405: DELETE FROM JTF_TTY_TERR_GRP_ACCTS
406: WHERE TERR_GROUP_ID = p_terr_gp_id;
407:
408: DELETE FROM JTF_TTY_NAMED_ACCTS na
409: WHERE na.NAMED_ACCOUNT_ID NOT IN

Line 410: (SELECT named_account_id FROM JTF_TTY_TERR_GRP_ACCTS);

406: WHERE TERR_GROUP_ID = p_terr_gp_id;
407:
408: DELETE FROM JTF_TTY_NAMED_ACCTS na
409: WHERE na.NAMED_ACCOUNT_ID NOT IN
410: (SELECT named_account_id FROM JTF_TTY_TERR_GRP_ACCTS);
411: /* delete the na mappings if a na is deleted or no reference to it exists */
412:
413: DELETE FROM JTF_TTY_ACCT_QUAL_MAPS nam
414: WHERE nam.NAMED_ACCOUNT_ID NOT IN

Line 523: JTF_TTY_TERR_GRP_ACCTS TGA,

519: SELECT tga.terr_group_account_id tga_id,
520: NAR.assigned_flag aflag,
521: tgo.rsc_group_id parentgrpid
522: FROM JTF_TTY_NAMED_ACCT_RSC NAR,
523: JTF_TTY_TERR_GRP_ACCTS TGA,
524: jtf_tty_terr_grp_owners tgo,
525: jtf_rs_groups_denorm gd
526: WHERE NAR.terr_group_account_id = TGA.terr_group_account_id
527: AND TGA.TERR_GROUP_ID = p_terr_gp_id

Line 545: JTF_TTY_TERR_GRP_ACCTS TGA

541: IS
542: SELECT tga.terr_group_account_id tga_id,
543: NAR.rsc_group_id currentgrpid
544: FROM JTF_TTY_NAMED_ACCT_RSC NAR,
545: JTF_TTY_TERR_GRP_ACCTS TGA
546: WHERE NAR.terr_group_account_id = TGA.terr_group_account_id
547: AND TGA.TERR_GROUP_ID = p_terr_gp_id
548: AND NAR.rsc_resource_type = 'RS_EMPLOYEE'
549: AND NOT EXISTS

Line 699: jtf_tty_terr_grp_accts tga,

695: LOOP
696: BEGIN
697: SELECT 'Y' INTO result
698: FROM jtf_tty_named_acct_rsc narsc,
699: jtf_tty_terr_grp_accts tga,
700: jtf_rs_role_relations rlt ,
701: jtf_rs_group_members grpmem ,
702: jtf_rs_groups_denorm grpdn
703: WHERE narsc.terr_group_account_id = tga.terr_group_account_id

Line 863: FROM jtf_tty_terr_grp_accts,

859: -- SOLIN, bug4943336, performance tuning
860: DELETE FROM jtf_tty_named_acct_rsc narsc
861: WHERE narsc.terr_group_account_id
862: IN ( SELECT terr_group_account_id
863: FROM jtf_tty_terr_grp_accts,
864: jtf_rs_role_relations rlt ,
865: jtf_rs_group_members grpmem ,
866: jtf_rs_groups_denorm grpdn
867: WHERE terr_group_id = p_terr_gp_id

Line 1172: FROM JTF_TTY_TERR_GRP_ACCTS

1168: /*
1169: DELETE from jtf_tty_acct_rsc_dn j
1170: WHERE j.TERR_GROUP_ACCOUNT_ID in
1171: (SELECT TERR_GROUP_ACCOUNT_ID
1172: FROM JTF_TTY_TERR_GRP_ACCTS
1173: WHERE TERR_GROUP_ID = p_terr_gp_id)
1174: AND j.RESOURCE_ID = p_resource_id
1175: AND j.RSC_GROUP_ID = p_group_id
1176: AND j.RSC_ROLE_CODE = p_role_code;

Line 1193: FROM JTF_TTY_TERR_GRP_ACCTS

1189: managed_group_id := group_data.group_id;
1190: DELETE from jtf_tty_named_acct_rsc j
1191: WHERE j.TERR_GROUP_ACCOUNT_ID in
1192: (SELECT TERR_GROUP_ACCOUNT_ID
1193: FROM JTF_TTY_TERR_GRP_ACCTS
1194: WHERE TERR_GROUP_ID = p_terr_gp_id)
1195: AND j.RESOURCE_ID IN (
1196: select resource_id
1197: from jtf_rs_group_members

Line 1204: FROM JTF_TTY_TERR_GRP_ACCTS

1200: /*
1201: DELETE from jtf_tty_acct_rsc_dn j
1202: WHERE j.TERR_GROUP_ACCOUNT_ID in
1203: (SELECT TERR_GROUP_ACCOUNT_ID
1204: FROM JTF_TTY_TERR_GRP_ACCTS
1205: WHERE TERR_GROUP_ID = p_terr_gp_id)
1206: AND j.RESOURCE_ID IN (
1207: select resource_id
1208: from jtf_rs_group_members

Line 1251: jtf_tty_terr_grp_accts tga

1247: 'RS_EMPLOYEE',
1248: na.site_type_code,
1249: count(na.NAMED_ACCOUNT_ID) num_accts
1250: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1251: jtf_tty_terr_grp_accts tga
1252: where na.named_account_id = tga.named_account_id
1253: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1254: and narsc.RESOURCE_ID IN (
1255: select resource_id

Line 1266: FROM JTF_TTY_TERR_GRP_ACCTS

1262: child_group_id := child_gp_data.group_id;
1263: DELETE from jtf_tty_named_acct_rsc j
1264: WHERE j.TERR_GROUP_ACCOUNT_ID in
1265: (SELECT TERR_GROUP_ACCOUNT_ID
1266: FROM JTF_TTY_TERR_GRP_ACCTS
1267: WHERE TERR_GROUP_ID = p_terr_gp_id)
1268: AND j.RESOURCE_ID IN (
1269: select resource_id
1270: from jtf_rs_group_members

Line 1277: FROM JTF_TTY_TERR_GRP_ACCTS

1273: /*
1274: DELETE from jtf_tty_acct_rsc_dn j
1275: WHERE j.TERR_GROUP_ACCOUNT_ID in
1276: (SELECT TERR_GROUP_ACCOUNT_ID
1277: FROM JTF_TTY_TERR_GRP_ACCTS
1278: WHERE TERR_GROUP_ID = p_terr_gp_id)
1279: AND j.RESOURCE_ID IN (
1280: select resource_id
1281: from jtf_rs_group_members

Line 1324: jtf_tty_terr_grp_accts tga

1320: 'RS_EMPLOYEE',
1321: na.site_type_code,
1322: count(na.NAMED_ACCOUNT_ID) num_accts
1323: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1324: jtf_tty_terr_grp_accts tga
1325: where na.named_account_id = tga.named_account_id
1326: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1327: and narsc.RESOURCE_ID IN (
1328: select resource_id

Line 1473: FROM jtf_tty_terr_grp_accts a, dual

1469: p_user_id,
1470: SYSDATE,
1471: p_user_id,
1472: SYSDATE
1473: FROM jtf_tty_terr_grp_accts a, dual
1474: WHERE terr_group_id = p_terr_gp_id
1475: AND NOT EXISTS
1476: ( SELECT NULL FROM jtf_tty_named_acct_rsc r
1477: WHERE r.TERR_GROUP_ACCOUNT_ID = a.TERR_GROUP_ACCOUNT_ID

Line 1522: from jtf_tty_terr_grp_accts a, dual

1518: p_user_id,
1519: sysdate,
1520: p_user_id,
1521: sysdate
1522: from jtf_tty_terr_grp_accts a, dual
1523: where terr_group_id = p_terr_gp_id
1524: AND NOT EXISTS
1525: ( SELECT NULL FROM jtf_tty_acct_rsc_dn r
1526: WHERE r.TERR_GROUP_ACCOUNT_ID = a.TERR_GROUP_ACCOUNT_ID

Line 1585: jtf_tty_terr_grp_accts tga, jtf_tty_terr_grp_owners tgo

1581: 'RS_EMPLOYEE',
1582: na.site_type_code,
1583: count(na.NAMED_ACCOUNT_ID) num_accts
1584: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1585: jtf_tty_terr_grp_accts tga, jtf_tty_terr_grp_owners tgo
1586: where na.named_account_id = tga.named_account_id
1587: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1588: and narsc.RESOURCE_ID = tgo.RESOURCE_ID
1589: and narsc.RSC_GROUP_ID = tgo.RSC_GROUP_ID

Line 1635: jtf_tty_terr_grp_accts tga

1631: 'RS_EMPLOYEE',
1632: na.site_type_code,
1633: count(na.NAMED_ACCOUNT_ID) num_accts
1634: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1635: jtf_tty_terr_grp_accts tga
1636: where na.named_account_id = tga.named_account_id
1637: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1638: and narsc.RESOURCE_ID = p_resource_id
1639: and narsc.RSC_GROUP_ID = p_rsc_group_id

Line 1732: jtf_tty_terr_grp_accts ga,

1728: CURSOR named_accounts_c IS
1729: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1730: FROM
1731: jtf_tty_named_accts na,
1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,
1736: jtf_rs_group_members mem,

Line 1756: jtf_tty_terr_grp_accts ga,

1752: CURSOR named_accounts_all_c IS
1753: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1754: FROM
1755: jtf_tty_named_accts na,
1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,
1760: jtf_rs_group_members mem,

Line 1802: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg

1798:
1799: CURSOR salesrep_named_accounts_c
1800: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1801: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1802: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1803: WHERE na.named_account_id = tga.named_account_id
1804: AND tga.terr_group_id = tg.terr_group_id
1805: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)
1806: AND (tg.active_to_date >= SYSDATE OR tg.active_to_date IS NULL)

Line 1816: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg

1812:
1813: CURSOR salesrep_named_accounts_all_c
1814: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1815: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1816: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1817: WHERE na.named_account_id = tga.named_account_id
1818: AND tga.terr_group_id = tg.terr_group_id
1819: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)
1820: AND (tg.active_to_date >= SYSDATE OR tg.active_to_date IS NULL)

Line 2127: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg

2123: 'RS_EMPLOYEE',
2124: na.site_type_code,
2125: count(na.NAMED_ACCOUNT_ID) num_accts
2126: from jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
2127: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
2128: where na.named_account_id = tga.named_account_id
2129: and tga.terr_group_id = tg.terr_group_id
2130: and (tg.active_from_date <= sysdate or tg.active_from_date is null)
2131: and (tg.active_to_date >= sysdate or tg.active_to_date is null)

Line 2191: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg

2187: 'RS_EMPLOYEE',
2188: na.site_type_code,
2189: count(na.NAMED_ACCOUNT_ID) num_accts
2190: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2191: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
2192: where na.named_account_id = tga.named_account_id
2193: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2194: and tga.terr_group_id = tg.terr_group_id
2195: and (tg.active_from_date <= sysdate or tg.active_from_date is null)

Line 2436: FROM JTF_TTY_TERR_GRP_ACCTS

2432: /* delete the existing assignments */
2433: DELETE FROM jtf_tty_named_acct_rsc j
2434: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2435: (SELECT TERR_GROUP_ACCOUNT_ID
2436: FROM JTF_TTY_TERR_GRP_ACCTS
2437: WHERE TERR_GROUP_ID = p_terr_gp_id)
2438: AND j.RESOURCE_ID = p_resource_id
2439: AND j.RSC_GROUP_ID = p_group_id
2440: AND j.RSC_ROLE_CODE = p_role_code;

Line 2448: FROM JTF_TTY_TERR_GRP_ACCTS

2444: /*
2445: DELETE from jtf_tty_acct_rsc_dn j
2446: WHERE j.TERR_GROUP_ACCOUNT_ID in
2447: (SELECT TERR_GROUP_ACCOUNT_ID
2448: FROM JTF_TTY_TERR_GRP_ACCTS
2449: WHERE TERR_GROUP_ID = p_terr_gp_id)
2450: AND j.RESOURCE_ID = p_resource_id
2451: AND j.RSC_GROUP_ID = p_group_id
2452: AND j.RSC_ROLE_CODE = p_role_code;

Line 2467: FROM JTF_TTY_TERR_GRP_ACCTS

2463: managed_group_id := group_data.group_id;
2464: DELETE FROM jtf_tty_named_acct_rsc j
2465: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2466: (SELECT TERR_GROUP_ACCOUNT_ID
2467: FROM JTF_TTY_TERR_GRP_ACCTS
2468: WHERE TERR_GROUP_ID = p_terr_gp_id)
2469: AND j.RESOURCE_ID IN (
2470: SELECT resource_id
2471: FROM jtf_rs_group_members

Line 2477: FROM JTF_TTY_TERR_GRP_ACCTS

2473: /*
2474: DELETE from jtf_tty_acct_rsc_dn j
2475: WHERE j.TERR_GROUP_ACCOUNT_ID in
2476: (SELECT TERR_GROUP_ACCOUNT_ID
2477: FROM JTF_TTY_TERR_GRP_ACCTS
2478: WHERE TERR_GROUP_ID = p_terr_gp_id)
2479: AND j.RESOURCE_ID IN (
2480: select resource_id
2481: from jtf_rs_group_members

Line 2524: jtf_tty_terr_grp_accts tga

2520: 'RS_EMPLOYEE',
2521: na.site_type_code,
2522: count(na.NAMED_ACCOUNT_ID) num_accts
2523: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2524: jtf_tty_terr_grp_accts tga
2525: where na.named_account_id = tga.named_account_id
2526: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2527: and narsc.RESOURCE_ID IN (
2528: select resource_id

Line 2538: FROM JTF_TTY_TERR_GRP_ACCTS

2534: child_group_id := child_gp_data.group_id;
2535: DELETE FROM jtf_tty_named_acct_rsc j
2536: WHERE j.TERR_GROUP_ACCOUNT_ID IN
2537: (SELECT TERR_GROUP_ACCOUNT_ID
2538: FROM JTF_TTY_TERR_GRP_ACCTS
2539: WHERE TERR_GROUP_ID = p_terr_gp_id)
2540: AND j.RESOURCE_ID IN (
2541: SELECT resource_id
2542: FROM jtf_rs_group_members

Line 2548: FROM JTF_TTY_TERR_GRP_ACCTS

2544: /*
2545: DELETE from jtf_tty_acct_rsc_dn j
2546: WHERE j.TERR_GROUP_ACCOUNT_ID in
2547: (SELECT TERR_GROUP_ACCOUNT_ID
2548: FROM JTF_TTY_TERR_GRP_ACCTS
2549: WHERE TERR_GROUP_ID = p_terr_gp_id)
2550: AND j.RESOURCE_ID IN (
2551: select resource_id
2552: from jtf_rs_group_members

Line 2595: jtf_tty_terr_grp_accts tga

2591: 'RS_EMPLOYEE',
2592: na.site_type_code,
2593: count(na.NAMED_ACCOUNT_ID) num_accts
2594: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2595: jtf_tty_terr_grp_accts tga
2596: where na.named_account_id = tga.named_account_id
2597: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2598: and narsc.RESOURCE_ID IN (
2599: select resource_id

Line 2800: DELETE FROM JTF_TTY_TERR_GRP_ACCTS

2796: DELETE FROM jtf_tty_named_acct_rsc j
2797: WHERE j.TERR_GROUP_ACCOUNT_ID = p_tga_id;
2798:
2799: -- delete grp account
2800: DELETE FROM JTF_TTY_TERR_GRP_ACCTS
2801: WHERE terr_group_account_id = p_tga_id;
2802:
2803: -- delete named account if no references to it exist
2804: DELETE FROM JTF_TTY_NAMED_ACCTS

Line 2807: (SELECT party_id FROM JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GRP_ACCTS tga

2803: -- delete named account if no references to it exist
2804: DELETE FROM JTF_TTY_NAMED_ACCTS
2805: WHERE party_id = p_party_id
2806: AND party_id NOT IN
2807: (SELECT party_id FROM JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GRP_ACCTS tga
2808: WHERE tga.named_account_id = na.named_account_id);
2809:
2810: COMMIT;
2811:

Line 3000: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

2996: -- check if any terr gp account exists
2997: BEGIN
2998: SELECT 1
2999: INTO p_grp_acct_count
3000: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3001: WHERE tga.named_account_id = tna.named_account_id
3002: AND tga.terr_group_id = p_terr_gp_id
3003: AND tna.party_id = p_party_id
3004: AND ROWNUM < 2;

Line 3014: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

3010:
3011: IF (p_grp_acct_count = 1) THEN
3012: SELECT tga.terr_group_account_id
3013: INTO p_terr_gp_acct_id
3014: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3015: WHERE tga.named_account_id = tna.named_account_id
3016: AND tga.terr_group_id = p_terr_gp_id
3017: AND tna.party_id = p_party_id;
3018: x_gp_acct_id := p_terr_gp_acct_id;

Line 3021: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL

3017: AND tna.party_id = p_party_id;
3018: x_gp_acct_id := p_terr_gp_acct_id;
3019: END IF;
3020:
3021: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3022: INTO p_terr_gp_acct_id
3023: FROM dual;
3024:
3025: -- assign a named account for the party to terr gp, if one does not exist

Line 3028: INSERT INTO JTF_TTY_TERR_GRP_ACCTS

3024:
3025: -- assign a named account for the party to terr gp, if one does not exist
3026: IF (p_grp_acct_count < 1) THEN
3027: x_gp_acct_id := p_terr_gp_acct_id;
3028: INSERT INTO JTF_TTY_TERR_GRP_ACCTS
3029: (TERR_GROUP_ACCOUNT_ID,
3030: OBJECT_VERSION_NUMBER ,
3031: TERR_GROUP_ID ,
3032: NAMED_ACCOUNT_ID,

Line 3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

3118: -- check if any terr gp account exists
3119:
3120: SELECT COUNT(tga.terr_group_account_id)
3121: INTO p_account_count
3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3123: WHERE tga.named_account_id = tna.named_account_id
3124: AND tna.party_id = p_party_id;
3125:
3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL

Line 3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL

3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3123: WHERE tga.named_account_id = tna.named_account_id
3124: AND tna.party_id = p_party_id;
3125:
3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3127: INTO p_terr_gp_acct_id
3128: FROM dual;
3129: -- assign a named account for the party to terr gp, if one does not exist
3130:

Line 3135: INSERT INTO JTF_TTY_TERR_GRP_ACCTS

3131: p_site_type_code := get_site_type_code(p_party_id);
3132:
3133: IF (p_account_count < 1) THEN
3134:
3135: INSERT INTO JTF_TTY_TERR_GRP_ACCTS
3136: (TERR_GROUP_ACCOUNT_ID,
3137: OBJECT_VERSION_NUMBER ,
3138: TERR_GROUP_ID ,
3139: NAMED_ACCOUNT_ID,