APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GROUP_USAGES

Line 414: jtf_rs_group_usages GU1,

410: FROM jtf_rs_groups_b G1,
411: jtf_rs_groups_b G2,
412: jtf_rs_group_members GM1,
413: jtf_rs_group_members GM2,
414: jtf_rs_group_usages GU1,
415: jtf_rs_group_usages GU2,
416: jtf_rs_role_relations RR1
417: /* commented the below line to improve the performance. We are not using this table in the select statement. */
418: -- jtf_rs_role_relations RR2

Line 415: jtf_rs_group_usages GU2,

411: jtf_rs_groups_b G2,
412: jtf_rs_group_members GM1,
413: jtf_rs_group_members GM2,
414: jtf_rs_group_usages GU1,
415: jtf_rs_group_usages GU2,
416: jtf_rs_role_relations RR1
417: /* commented the below line to improve the performance. We are not using this table in the select statement. */
418: -- jtf_rs_role_relations RR2
419: WHERE GM2.group_member_id = l_member_id

Line 1530: jtf_rs_group_usages GU1,

1526: FROM jtf_rs_groups_b G1,
1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1
1533: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1534: -- jtf_rs_role_relations RR2

Line 1531: jtf_rs_group_usages GU2,

1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1
1533: /* commented the below line to improve the performance. We are not using this table in the select statement. */
1534: -- jtf_rs_role_relations RR2
1535: WHERE GM2.group_member_id = l_member_id