DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_REQ_LINES_ACC

Line 314: FROM csm_req_lines_acc acc

310: AND au.resource_id=jta.resource_id
311: AND au.user_id=p_user_id
312: AND NOT EXISTS
313: (SELECT 1
314: FROM csm_req_lines_acc acc
315: WHERE acc.requirement_line_id = line.requirement_line_id
316: AND acc.user_id = au.user_id
317: );
318:

Line 1396: csm_req_lines_acc acc

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
1399: AND line.requirement_header_id = hdr.requirement_header_id
1400: AND acc.requirement_line_id = line.requirement_line_id