APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 1244: from csp_requirement_headers crh,

1240: x_msg_count OUT NOCOPY varchar2) IS
1241: cursor reservations
1242: IS
1243: Select crld.source_id,crld.req_line_detail_id,crh.requirement_header_id
1244: from csp_requirement_headers crh,
1245: csp_requirement_lines crl,
1246: csp_req_line_details crld
1247: where crh.task_assignment_id = p_task_assignment_id
1248: and crl.requirement_header_id = crh.requirement_header_id

Line 1302: csp_requirement_headers_pkg.update_row(

1298: END IF;
1299: END LOOP;
1300: CLOSE reservations;
1301: if l_requirement_header_id is not null then
1302: csp_requirement_headers_pkg.update_row(
1303: p_requirement_header_id => l_requirement_header_id,
1304: p_open_requirement => 'N');
1305: end if;
1306: END relieve_reservations;