APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 568: FROM jtf_rs_group_members gm1, jtf_rs_role_relations rrl1, jtf_rs_roles_b rol1

564: -- changed on 01/16/2004 for dbi 7.0
565: SELECT /*+ use_hash(gm1 rrl1 rol1 usg1) PARALLEL(gm1) PARALLEL(rrl1) PARALLEL(rol1) PARALLEL(usg1)*/
566: DISTINCT gm1.resource_id, gm1.group_id
567: , 'A' mem_status, usg1.usage
568: FROM jtf_rs_group_members gm1, jtf_rs_role_relations rrl1, jtf_rs_roles_b rol1
569: ,jtf_rs_group_usages usg1
570: WHERE gm1.group_member_id = rrl1.role_resource_id
571: AND gm1.delete_flag = 'N'
572: AND rrl1.role_resource_type = 'RS_GROUP_MEMBER'

Line 583: FROM jtf_rs_group_members gm2, jtf_rs_role_relations rrl2, jtf_rs_roles_b rol2

579: UNION ALL
580: SELECT /*+ use_hash(gm2 rrl2 rol2 usg2) PARALLEL(gm2) PARALLEL(rrl2) PARALLEL(rol2) PARALLEL(usg2) */
581: DISTINCT gm2.resource_id, gm2.group_id
582: , 'I' mem_status, usg2.usage
583: FROM jtf_rs_group_members gm2, jtf_rs_role_relations rrl2, jtf_rs_roles_b rol2
584: ,jtf_rs_group_usages usg2
585: WHERE gm2.group_member_id = rrl2.role_resource_id
586: AND gm2.delete_flag = 'N'
587: AND rrl2.role_resource_type = 'RS_GROUP_MEMBER'

Line 597: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3

593: AND usg2.usage = l_usage
594: AND NOT EXISTS ( -- to check if active role doesn't exist
595: SELECT /*+ use_hash(gm3 rrl3 rol3 usg3) PARALLEL(gm3) PARALLEL(rrl3) PARALLEL(rol3) PARALLEL(usg3)*/
596: '1'
597: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3
598: , jtf_rs_roles_b rol3
599: , jtf_rs_group_usages usg3
600: WHERE gm3.group_member_id = rrl3.role_resource_id
601: AND gm3.delete_flag = 'N'

Line 639: ,jtf_rs_role_relations rrl

635: MIN(rrl.start_date_active) start_date,
636: MAX(nvl(rrl.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))) end_date,
637: usg.usage
638: FROM jtf_rs_group_members gm
639: ,jtf_rs_role_relations rrl
640: ,jtf_rs_roles_b rol
641: ,jtf_rs_resource_extns_vl res
642: ,jtf_rs_group_usages usg
643: WHERE gm.delete_flag = 'N'