APPS.JTF_TASK_SECURITY_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 101: FROM jtf_task_all_assignments, jtf_rs_group_members

97: THEN
98: BEGIN
99: SELECT 1
100: INTO x
101: FROM jtf_task_all_assignments, jtf_rs_group_members
102: WHERE task_id = p_task_id
103: AND jtf_task_all_assignments.resource_id = group_id
104: AND resource_type_code = 'RS_GROUP'
105: AND jtf_rs_group_members.resource_id = p_resource_id

Line 105: AND jtf_rs_group_members.resource_id = p_resource_id

101: FROM jtf_task_all_assignments, jtf_rs_group_members
102: WHERE task_id = p_task_id
103: AND jtf_task_all_assignments.resource_id = group_id
104: AND resource_type_code = 'RS_GROUP'
105: AND jtf_rs_group_members.resource_id = p_resource_id
106: AND ROWNUM < 2;
107:
108: l_current_privelege := 'FULL';
109: EXCEPTION

Line 280: FROM jtf_task_all_assignments, jtf_rs_group_members

276: /* Bug 2186841 Private Tasks belonging to a group can't be queried upon */
277: BEGIN
278: SELECT 1
279: INTO x
280: FROM jtf_task_all_assignments, jtf_rs_group_members
281: WHERE task_id = p_task_id
282: AND jtf_task_all_assignments.resource_id = group_id
283: AND resource_type_code = 'RS_GROUP'
284: AND jtf_rs_group_members.resource_id = p_resource_id

Line 284: AND jtf_rs_group_members.resource_id = p_resource_id

280: FROM jtf_task_all_assignments, jtf_rs_group_members
281: WHERE task_id = p_task_id
282: AND jtf_task_all_assignments.resource_id = group_id
283: AND resource_type_code = 'RS_GROUP'
284: AND jtf_rs_group_members.resource_id = p_resource_id
285: AND ROWNUM < 2;
286: return 'Y' ;
287:
288: EXCEPTION

Line 363: from jtf_rs_group_members

359: if priveleges_from_resource_type = 'RS_GROUP' then
360: begin
361: select 1
362: into l_privlege_name
363: from jtf_rs_group_members
364: where group_id = priveleges_from_resource_id
365: and resource_id = logged_in_resource
366: and rownum < 2;
367: