eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_SECURITY_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 88: FROM jtf_task_all_assignments

84:
85: BEGIN
86: SELECT 1
87: INTO x
88: FROM jtf_task_all_assignments
89: WHERE task_id = p_task_id
90: AND resource_id = p_resource_id
91: AND resource_type_code = p_resource_type
92: AND ROWNUM < 2;

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 103: AND jtf_task_all_assignments.resource_id = group_id

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
106: AND ROWNUM < 2;
107:

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 116: AND jtf_task_all_assignments.resource_id = team_id

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
119: AND ROWNUM < 2;
120:

Line 238: from jtf_task_all_assignments

234:
235:
236: BEGIN
237: select category_id into l_category_id
238: from jtf_task_all_assignments
239: where task_id = p_task_id
240: and resource_id = p_resource_id
241: and resource_type_code = p_resource_type_code
242: and rownum < 2;

Line 267: from jtf_task_all_assignments

263: begin
264: /* for optimization, the UI should check if the task is private .*/
265:
266: select 1 into x
267: from jtf_task_all_assignments
268: where task_id = p_task_id
269: and p_resource_id = resource_id
270: and p_resource_type_code = resource_type_code ;
271:

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 282: AND jtf_task_all_assignments.resource_id = group_id

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
285: AND ROWNUM < 2;
286: return 'Y' ;

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 295: AND jtf_task_all_assignments.resource_id = team_id

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
298: AND ROWNUM < 2;
299: return 'Y' ;

Line 319: update jtf_task_all_assignments

315: select perz_data_id into l_perz_data_id
316: from jtf_perz_data
317: where perz_data_name = p_category_name ;
318:
319: update jtf_task_all_assignments
320: set category_id = null
321: where category_id = l_perz_data_id ;
322:
323: update jtf_cal_addresses