DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSP_REQUIREMENT_LINES

Line 305: csp_requirement_lines line,

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
309: AND line.requirement_header_id = hdr.requirement_header_id

Line 1395: csp_requirement_lines line,

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