408: FROM jtf_rs_groups_b G1,
409: jtf_rs_groups_b G2,
410: jtf_rs_group_members GM1,
411: jtf_rs_group_members GM2,
412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1
415: /* commented the below line to improve the performance. We are not using this table in the select statement. */
416: -- jtf_rs_role_relations RR2
409: jtf_rs_groups_b G2,
410: jtf_rs_group_members GM1,
411: jtf_rs_group_members GM2,
412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1
415: /* commented the below line to improve the performance. We are not using this table in the select statement. */
416: -- jtf_rs_role_relations RR2
417: WHERE GM2.group_member_id = l_member_id
1512: FROM jtf_rs_groups_b G1,
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1
1519: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1520: -- jtf_rs_role_relations RR2
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1
1519: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1520: -- jtf_rs_role_relations RR2
1521: WHERE GM2.group_member_id = l_member_id