APPS.AMS_ACCESS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 2018: FROM jtf_rs_group_members

2014: -- Cursor to Find all the group the user is in
2015: --
2016: CURSOR c_all_grp IS
2017: SELECT group_id
2018: FROM jtf_rs_group_members
2019: WHERE resource_id = p_user_id
2020: AND delete_flag = 'N' ;
2021:
2022: --

Line 2224: -- FROM ams_act_access A, jtf_rs_group_members_vl B

2220: -- SELECT 1
2221: -- FROM DUAL
2222: -- WHERE EXISTS(
2223: -- SELECT 1
2224: -- FROM ams_act_access A, jtf_rs_group_members_vl B
2225: -- WHERE A.arc_act_access_to_object = p_object_type
2226: -- AND A.act_access_to_object_id = p_object_id
2227: -- AND A.arc_user_or_role_type = 'GROUP'
2228: -- AND (A.active_from_date IS NULL OR A.active_from_date <= SYSDATE)

Line 3064: FROM jtf_rs_group_members

3060: l_admin NUMBER ;
3061:
3062: CURSOR c_members(p_group_id NUMBER) IS
3063: SELECT resource_id
3064: FROM jtf_rs_group_members
3065: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
3066: --FROM jtf_rs_group_members_vl
3067: WHERE group_id = p_group_id
3068: AND resource_id = p_resource_id

Line 3066: --FROM jtf_rs_group_members_vl

3062: CURSOR c_members(p_group_id NUMBER) IS
3063: SELECT resource_id
3064: FROM jtf_rs_group_members
3065: -- commented by ptendulk on 22-Jan-2001 Ref Bug #1607548
3066: --FROM jtf_rs_group_members_vl
3067: WHERE group_id = p_group_id
3068: AND resource_id = p_resource_id
3069: AND delete_flag = 'N' ;
3070: