APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSP_REQ_LINE_DETAILS

Line 486: csp_req_line_details crld,

482: mr.reservation_uom_code,
483: SUM(mr.reservation_quantity)
484: FROM csp_requirement_headers crh,
485: csp_requirement_lines crl,
486: csp_req_line_details crld,
487: mtl_reservations mr
488: WHERE crh.task_assignment_id = p_task_assignment_id
489: AND crl.requirement_header_id = crh.requirement_header_id
490: AND crld.requirement_line_id = crl.requirement_line_id

Line 1790: csp_req_line_details crld,

1786: is
1787: Select crld.source_id,crld.req_line_detail_id,crh.requirement_header_id,mr.reservation_quantity
1788: from csp_requirement_headers crh,
1789: csp_requirement_lines crl,
1790: csp_req_line_details crld,
1791: mtl_reservations mr
1792: where crh.task_assignment_id = p_task_assignment_id
1793: and crl.requirement_header_id = crh.requirement_header_id
1794: and crld.requirement_line_id = crl.requirement_line_id

Line 1885: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);

1881: exit;
1882: end if;
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: if nvl(l_remaining_quantity, 0) <= 0 then
1885: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);
1886: end if;
1887:
1888: log('relieve_reservations', 'reducing relieved quantity now');
1889: log('relieve_reservations', 'current l_relieved_quantity=' || l_relieved_quantity);