[Home] [Help]
1293: jtf_tty_terr_grp_owners jto,
1294: jtf_rs_resource_extns res
1295: WHERE EXISTS
1296: ( SELECT NULL
1297: FROM jtf_rs_groups_denorm grpd
1298: WHERE /* part of Salesgroup hierarchy of Territory Group owner */
1299: grpd.parent_group_id = JTO.rsc_group_id
1300: /* groups I (logged-in user) am 'member' of */
1301: AND grpd.group_id = GRV.group_id
1708: -- LIST OF ALL GROUPS A GIVEN RESOURCE OWNS IN THE CONTEXT OF A PARENT GRUOP
1709: cursor c_rsc_owned_grps(cl_parent_resource_id number, cl_group_id number) is
1710: SELECT mgr.resource_id, mgr.group_id
1711: FROM jtf_rs_rep_managers mgr,
1712: jtf_rs_groups_denorm gd
1713: WHERE mgr.hierarchy_type = 'MGR_TO_MGR'
1714: AND mgr.resource_id = mgr.parent_resource_id
1715: AND trunc(sysdate) BETWEEN mgr.start_date_active
1716: AND NVL(mgr.end_date_active,trunc(sysdate))
1769: cursor c_groups_manager(cl_current_user_id number, cl_eff_resource_id number ) is
1770: select grv.resource_id, grv.group_id, grv.role_code
1771: from
1772: jtf_tty_my_resources_v grv
1773: , JTF_RS_GROUPS_DENORM grpd
1774: , jtf_rs_roles_b rol
1775: WHERE grpd.parent_group_id = grv.parent_group_id
1776: and grpd.group_id IN ( select grv1.group_id
1777: from jtf_rs_group_members grv1
1902: where ar.terr_group_account_id = l_terr_group_account_id
1903: and exists (
1904: select 1
1905: from jtf_tty_my_resources_v grv
1906: , jtf_rs_groups_denorm grpd
1907: WHERE ar.resource_id = grv.resource_id
1908: and grpd.parent_group_id = grv.parent_group_id
1909: and exists (
1910: select 1
2385: where TERR_GROUP_ACCOUNT_ID = l_terr_grp_acct_id
2386: and (l_sales_group is null
2387: or RSC_GROUP_ID in
2388: (select group_id
2389: from jtf_rs_groups_denorm
2390: where parent_group_id = l_sales_group))
2391: and (l_sales_role is null
2392: or RSC_ROLE_CODE = l_sales_role);
2393: