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
260: FROM csm_req_headers_acc acc
261: WHERE acc.requirement_header_id = hdr.requirement_header_id
262: AND acc.user_id = p_user_id
263: );
264:
1343: WHERE jta.task_assignment_id = p_task_assg_id
1344: AND hdr.task_id = jta.task_id
1345: AND EXISTS
1346: (SELECT 1
1347: FROM csm_req_headers_acc acc
1348: WHERE acc.requirement_header_id = hdr.requirement_header_id
1349: AND acc.user_id = p_user_id
1350: );
1351: