[Home] [Help]
179:
180: BEGIN
181: SELECT 'VALID'
182: INTO l_select
183: FROM jtf_rs_group_members mem,
184: jtf_rs_roles_b rol,
185: jtf_rs_role_relations rlt
186: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
187: AND rlt.delete_flag = 'N'
450: , MY_GRPS.current_user_role_code
451: , MY_GRPS.current_user_rsc_id
452: FROM jtf_rs_roles_vl rol
453: , jtf_rs_role_relations rlt
454: , jtf_rs_group_members grpmemo
455: , jtf_rs_resource_extns_vl dir
456:
457: , ( /* MY_GRPS INLINE VIEW */
458: /* Groups logged-in user manages/administrates */
501: , rol.role_code current_user_role_code
502: , dir.resource_id current_user_rsc_id
503: FROM jtf_rs_roles_vl rol
504: , jtf_rs_role_relations rlt
505: , jtf_rs_group_members grpmemo
506: , jtf_rs_resource_extns_vl dir
507: , ( /* SALES GROUPS INLINE VIEW */
508: SELECT dv.group_id
509: , dv.group_id PARENT_GROUP_ID
715: rol.role_code
716: FROM jtf_rs_rep_managers repmgr,
717: jtf_rs_role_relations rlt,
718: jtf_rs_roles_b rol,
719: jtf_rs_group_members grpmem
720: WHERE repmgr.resource_id = c_resource_id
721: AND repmgr.group_id = c_group_id
722: AND repmgr.par_role_relate_id = rlt.role_relate_id
723: AND SYSDATE BETWEEN repmgr.start_date_active
849: FROM jtf_tty_named_acct_rsc narsc
850: WHERE narsc.terr_group_account_id = l_terr_grp_acct_id
851: AND EXISTS (
852: SELECT 'Y'
853: FROM jtf_rs_group_members grpmemo ,
854: jtf_rs_resource_extns dir ,
855: ( SELECT /*+ NO_MERGE */ dv.group_id ,
856: mrsc.user_id CURRENT_USER_ID
857: FROM jtf_rs_group_usages usg ,
876: AND grpmemo.resource_id = narsc.resource_id
877: AND grpmemo.group_id = narsc.rsc_group_id
878: UNION ALL
879: SELECT 'Y'
880: FROM jtf_rs_group_members grpmemo ,
881: jtf_rs_resource_extns dir ,
882: jtf_rs_group_usages usg
883: WHERE usg.usage = 'SALES'
884: AND grpmemo.resource_id = dir.resource_id