APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_ROLE_RELATIONS

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

557: -- changed on 01/16/2004 for dbi 7.0
558: SELECT /*+ use_hash(gm1 rrl1 rol1 usg1) PARALLEL(gm1) PARALLEL(rrl1) PARALLEL(rol1) PARALLEL(usg1)*/
559: DISTINCT gm1.resource_id, gm1.group_id
560: , 'A' mem_status, usg1.usage
561: FROM jtf_rs_group_members gm1, jtf_rs_role_relations rrl1, jtf_rs_roles_b rol1
562: ,jtf_rs_group_usages usg1
563: WHERE gm1.group_member_id = rrl1.role_resource_id
564: AND gm1.delete_flag = 'N'
565: AND rrl1.role_resource_type = 'RS_GROUP_MEMBER'

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

572: UNION ALL
573: SELECT /*+ use_hash(gm2 rrl2 rol2 usg2) PARALLEL(gm2) PARALLEL(rrl2) PARALLEL(rol2) PARALLEL(usg2) */
574: DISTINCT gm2.resource_id, gm2.group_id
575: , 'I' mem_status, usg2.usage
576: FROM jtf_rs_group_members gm2, jtf_rs_role_relations rrl2, jtf_rs_roles_b rol2
577: ,jtf_rs_group_usages usg2
578: WHERE gm2.group_member_id = rrl2.role_resource_id
579: AND gm2.delete_flag = 'N'
580: AND rrl2.role_resource_type = 'RS_GROUP_MEMBER'

Line 590: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3

586: AND usg2.usage = l_usage
587: AND NOT EXISTS ( -- to check if active role doesn't exist
588: SELECT /*+ use_hash(gm3 rrl3 rol3 usg3) PARALLEL(gm3) PARALLEL(rrl3) PARALLEL(rol3) PARALLEL(usg3)*/
589: '1'
590: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3
591: , jtf_rs_roles_b rol3
592: , jtf_rs_group_usages usg3
593: WHERE gm3.group_member_id = rrl3.role_resource_id
594: AND gm3.delete_flag = 'N'

Line 632: ,jtf_rs_role_relations rrl

628: MIN(rrl.start_date_active) start_date,
629: MAX(nvl(rrl.end_date_active,TO_DATE('12/31/4712','MM/DD/RRRR'))) end_date,
630: usg.usage
631: FROM jtf_rs_group_members gm
632: ,jtf_rs_role_relations rrl
633: ,jtf_rs_roles_b rol
634: ,jtf_rs_resource_extns_vl res
635: ,jtf_rs_group_usages usg
636: WHERE gm.delete_flag = 'N'