APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_TERR_GRP_OWNERS

Line 418: DELETE FROM jtf_tty_terr_grp_owners

414: WHERE nam.NAMED_ACCOUNT_ID NOT IN
415: (SELECT named_account_id FROM JTF_TTY_NAMED_ACCTS);
416:
417: /* delete all the terr gp owners, access and product */
418: DELETE FROM jtf_tty_terr_grp_owners
419: WHERE terr_group_id = p_terr_gp_id;
420:
421: DELETE FROM jtf_tty_role_prod_int
422: WHERE terr_group_role_id IN

Line 524: jtf_tty_terr_grp_owners tgo,

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
528: AND NAR.rsc_resource_type = 'RS_EMPLOYEE'

Line 552: FROM jtf_tty_terr_grp_owners tgo,

548: AND NAR.rsc_resource_type = 'RS_EMPLOYEE'
549: AND NOT EXISTS
550: (
551: SELECT NULL
552: FROM jtf_tty_terr_grp_owners tgo,
553: jtf_rs_groups_denorm gd
554: WHERE gd.group_id = NAR.RSC_GROUP_ID
555: AND gd.parent_group_id = tgo.rsc_group_id
556: AND tgo.rsc_resource_type = 'RS_EMPLOYEE'

Line 566: FROM jtf_tty_terr_grp_owners tgo

562: IS
563: SELECT rsc_group_id,
564: resource_id,
565: rsc_role_code
566: FROM jtf_tty_terr_grp_owners tgo
567: WHERE terr_group_id = p_terr_gp_id
568: AND rsc_resource_type = 'RS_EMPLOYEE';
569: */
570:

Line 1547: from jtf_tty_terr_grp_owners

1543: /*
1544: delete from jtf_tty_rsc_acct_summ
1545: where resource_id in(
1546: select resource_id
1547: from jtf_tty_terr_grp_owners
1548: where terr_group_id = p_terr_gp_id)
1549: and rsc_group_id in(
1550: select rsc_group_id
1551: from jtf_tty_terr_grp_owners

Line 1551: from jtf_tty_terr_grp_owners

1547: from jtf_tty_terr_grp_owners
1548: where terr_group_id = p_terr_gp_id)
1549: and rsc_group_id in(
1550: select rsc_group_id
1551: from jtf_tty_terr_grp_owners
1552: where terr_group_id = p_terr_gp_id);
1553:
1554:
1555: insert into jtf_tty_rsc_acct_summ(

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 1667: FROM JTF_TTY_TERR_GRP_OWNERS tgo,

1663: p_num_geos NUMBER;
1664:
1665: CURSOR ALL_OWNER_USERS_C
1666: IS SELECT DISTINCT rs.user_id, tgo.rsc_group_id
1667: FROM JTF_TTY_TERR_GRP_OWNERS tgo,
1668: JTF_RS_RESOURCE_EXTNS rs
1669: WHERE rs.resource_id = tgo.resource_id;
1670:
1671: CURSOR all_managers_c

Line 2211: DELETE FROM jtf_tty_terr_grp_owners

2207:
2208: BEGIN
2209:
2210: /* delete all the territory group owners */
2211: DELETE FROM jtf_tty_terr_grp_owners
2212: WHERE terr_group_id = p_terr_gp_id;
2213:
2214: /* delete all the roles, first the product interests, access and finally the roles */
2215: DELETE FROM jtf_tty_role_prod_int

Line 3293: INSERT INTO jtf_tty_terr_grp_owners(

3289: p_resource_type IN VARCHAR2 DEFAULT 'RS_EMPLOYEE')
3290: AS
3291:
3292: BEGIN
3293: INSERT INTO jtf_tty_terr_grp_owners(
3294: TERR_GROUP_OWNER_ID,
3295: OBJECT_VERSION_NUMBER,
3296: TERR_GROUP_ID,
3297: RSC_GROUP_ID,

Line 3307: VALUES(jtf_tty_terr_grp_owners_s.NEXTVAL,

3303: LAST_UPDATE_LOGIN,
3304: RSC_ROLE_CODE ,
3305: RSC_RESOURCE_TYPE
3306: )
3307: VALUES(jtf_tty_terr_grp_owners_s.NEXTVAL,
3308: 1,
3309: p_terr_gp_id,
3310: p_rsc_gp_id,
3311: p_resource_id,