251: IS
252: SELECT hdr.requirement_header_id,
253: jta.resource_id
254: FROM jtf_task_assignments jta,
255: csp_requirement_headers hdr
256: WHERE jta.task_assignment_id = p_task_assg_id
257: AND hdr.task_id = jta.task_id
258: AND NOT EXISTS
259: (SELECT 1
300: p_user_id IN NUMBER)
301: IS
302: SELECT line.requirement_line_id
303: FROM jtf_task_assignments jta,
304: csp_requirement_headers hdr,
305: csp_requirement_lines line,
306: asg_user au
307: WHERE jta.task_assignment_id = p_task_assg_id
308: AND hdr.task_id = jta.task_id
1338: IS
1339: SELECT hdr.requirement_header_id,
1340: jta.resource_id
1341: FROM jtf_task_assignments jta,
1342: csp_requirement_headers hdr
1343: WHERE jta.task_assignment_id = p_task_assg_id
1344: AND hdr.task_id = jta.task_id
1345: AND EXISTS
1346: (SELECT 1
1390: SELECT line.requirement_line_id,
1391: line.requirement_header_id,
1392: acc.user_id
1393: FROM jtf_task_assignments jta,
1394: csp_requirement_headers hdr,
1395: csp_requirement_lines line,
1396: csm_req_lines_acc acc
1397: WHERE jta.task_assignment_id = p_task_assg_id
1398: AND hdr.task_id = jta.task_id