DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GROUP_USAGES

Line 412: jtf_rs_group_usages GU1,

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

Line 413: jtf_rs_group_usages GU2,

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

Line 1516: jtf_rs_group_usages GU1,

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

Line 1517: jtf_rs_group_usages GU2,

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