APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 484: FROM csp_requirement_headers crh,

480: cursor c_item_reservations (p_task_assignment_id number, p_inventory_item_id number) is
481: SELECT mr.inventory_item_id,
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

Line 1788: from csp_requirement_headers crh,

1784: x_msg_count OUT NOCOPY varchar2) IS
1785: cursor reservations
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

Line 1899: csp_requirement_headers_pkg.update_row(

1895: END IF;
1896: END LOOP;
1897: CLOSE reservations;
1898: if l_requirement_header_id is not null then
1899: csp_requirement_headers_pkg.update_row(
1900: p_requirement_header_id => l_requirement_header_id,
1901: p_open_requirement => 'N');
1902: end if;
1903: END relieve_reservations;