[Home] [Help]
1288: /* find if the resource belongs to the saleshierarchy of the territory group owner(s) since when an
1289: admin is doing upload, he/she is doing as the owner of the TG */
1290: SELECT 'VALID'
1291: INTO l_select
1292: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
1293: jtf_tty_terr_grp_owners jto,
1294: jtf_rs_resource_extns res
1295: WHERE EXISTS
1296: ( SELECT NULL
1573: BEGIN
1574: SELECT 'X'
1575: INTO p_exists_flag
1576: FROM jtf_tty_terr_grp_accts ga,
1577: jtf_tty_my_resources_v repdn,
1578: jtf_tty_named_acct_rsc narsc
1579: WHERE ga.terr_group_account_id = narsc.terr_group_account_id
1580: AND narsc.resource_id = repdn.resource_id
1581: AND narsc.rsc_group_id = repdn.group_id
1751: and gai.terr_group_account_id = cl_terr_group_account_id
1752: -- subsidiaries that are owned by user
1753: and exists( select 'Y'
1754: from jtf_tty_named_acct_rsc narsc ,
1755: jtf_tty_my_resources_v repdn
1756: -- jtf_tty_named_accts na,
1757: -- jtf_tty_terr_grp_accts ga
1758: where narsc.terr_group_account_id = gao.terr_group_account_id
1759: -- and ga.named_account_id = na.named_account_id
1768:
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
1901: from jtf_tty_named_acct_rsc ar
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 (