DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSP_REQUIREMENT_LINES

Line 307: csp_requirement_lines line

303: line.requirement_header_id,
304: jta.resource_id
305: FROM jtf_task_assignments jta,
306: csp_requirement_headers hdr,
307: csp_requirement_lines line
308: WHERE jta.task_assignment_id = p_task_assg_id
309: AND hdr.task_id = jta.task_id
310: AND line.requirement_header_id = hdr.requirement_header_id
311: AND NOT EXISTS

Line 1327: csp_requirement_lines line,

1323: line.requirement_header_id,
1324: acc.user_id
1325: FROM jtf_task_assignments jta,
1326: csp_requirement_headers hdr,
1327: csp_requirement_lines line,
1328: csm_req_lines_acc acc
1329: WHERE jta.task_assignment_id = p_task_assg_id
1330: AND hdr.task_id = jta.task_id
1331: AND line.requirement_header_id = hdr.requirement_header_id