APPS.IBC_DATA_SECURITY_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 3990: FROM jtf_rs_group_members

3986: WHERE resource_id = p_resource_id;
3987:
3988: CURSOR c_grp_members(p_resource_id NUMBER) IS
3989: SELECT group_id group_id, resource_id group_resource_id, 'INDIVIDUAL' resource_type
3990: FROM jtf_rs_group_members
3991: WHERE group_id = p_resource_id
3992: AND delete_flag = 'N'
3993: UNION
3994: SELECT rgm.group_id group_id, rgr.group_id group_resource_id, 'GROUP' resource_type

Line 3995: FROM jtf_rs_group_members rgm, jtf_rs_grp_relations rgr

3991: WHERE group_id = p_resource_id
3992: AND delete_flag = 'N'
3993: UNION
3994: SELECT rgm.group_id group_id, rgr.group_id group_resource_id, 'GROUP' resource_type
3995: FROM jtf_rs_group_members rgm, jtf_rs_grp_relations rgr
3996: WHERE rgm.group_id = rgr.related_group_id
3997: AND rgm.group_id = p_resource_id
3998: AND rgm.delete_flag = 'N'
3999: AND rgr.delete_flag = 'N';