APPS.JTF_TASK_SECURITY_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 114: FROM jtf_task_all_assignments, jtf_rs_team_members

110: WHEN NO_DATA_FOUND THEN
111: BEGIN
112: SELECT 1
113: INTO x
114: FROM jtf_task_all_assignments, jtf_rs_team_members
115: WHERE task_id = p_task_id
116: AND jtf_task_all_assignments.resource_id = team_id
117: AND resource_type_code = 'RS_TEAM'
118: AND jtf_rs_team_members.team_resource_id = p_resource_id

Line 118: AND jtf_rs_team_members.team_resource_id = p_resource_id

114: FROM jtf_task_all_assignments, jtf_rs_team_members
115: WHERE task_id = p_task_id
116: AND jtf_task_all_assignments.resource_id = team_id
117: AND resource_type_code = 'RS_TEAM'
118: AND jtf_rs_team_members.team_resource_id = p_resource_id
119: AND ROWNUM < 2;
120:
121: l_current_privelege := 'FULL';
122: EXCEPTION

Line 293: FROM jtf_task_all_assignments, jtf_rs_team_members

289: WHEN NO_DATA_FOUND THEN
290: BEGIN
291: SELECT 1
292: INTO x
293: FROM jtf_task_all_assignments, jtf_rs_team_members
294: WHERE task_id = p_task_id
295: AND jtf_task_all_assignments.resource_id = team_id
296: AND resource_type_code = 'RS_TEAM'
297: AND jtf_rs_team_members.team_resource_id = p_resource_id

Line 297: AND jtf_rs_team_members.team_resource_id = p_resource_id

293: FROM jtf_task_all_assignments, jtf_rs_team_members
294: WHERE task_id = p_task_id
295: AND jtf_task_all_assignments.resource_id = team_id
296: AND resource_type_code = 'RS_TEAM'
297: AND jtf_rs_team_members.team_resource_id = p_resource_id
298: AND ROWNUM < 2;
299: return 'Y' ;
300:
301: EXCEPTION

Line 380: from jtf_rs_team_members

376: if priveleges_from_resource_type = 'RS_TEAM' then
377: begin
378: select 1
379: into l_privlege_name
380: from jtf_rs_team_members
381: where TEAM_id = priveleges_from_resource_id
382: and TEAM_resource_id = logged_in_resource
383: and rownum < 2;
384: