DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_REQ_HEADERS_ACC

Line 260: FROM csm_req_headers_acc acc

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:

Line 1347: FROM csm_req_headers_acc acc

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: