APPS.AMS_ACCESS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1675: FROM jtf_rs_group_members

1671: -- Cursor to Find all the group the user is in
1672: --
1673: CURSOR c_all_grp IS
1674: SELECT group_id
1675: FROM jtf_rs_group_members
1676: WHERE resource_id = p_user_id
1677: AND delete_flag = 'N' ;
1678:
1679: --

Line 1881: -- FROM ams_act_access A, jtf_rs_group_members_vl B

1877: -- SELECT 1
1878: -- FROM DUAL
1879: -- WHERE EXISTS(
1880: -- SELECT 1
1881: -- FROM ams_act_access A, jtf_rs_group_members_vl B
1882: -- WHERE A.arc_act_access_to_object = p_object_type
1883: -- AND A.act_access_to_object_id = p_object_id
1884: -- AND A.arc_user_or_role_type = 'GROUP'
1885: -- AND (A.active_from_date IS NULL OR A.active_from_date <= SYSDATE)

Line 2721: FROM jtf_rs_group_members

2717: l_admin NUMBER ;
2718:
2719: CURSOR c_members(p_group_id NUMBER) IS
2720: SELECT resource_id
2721: FROM jtf_rs_group_members
2722: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2723: --FROM jtf_rs_group_members_vl
2724: WHERE group_id = p_group_id
2725: AND resource_id = p_resource_id

Line 2723: --FROM jtf_rs_group_members_vl

2719: CURSOR c_members(p_group_id NUMBER) IS
2720: SELECT resource_id
2721: FROM jtf_rs_group_members
2722: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
2723: --FROM jtf_rs_group_members_vl
2724: WHERE group_id = p_group_id
2725: AND resource_id = p_resource_id
2726: AND delete_flag = 'N' ;
2727: