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
1249: and crld.requirement_line_id = crl.requirement_line_id
1250: and crld.source_type = 'RES';
1293: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
1294: exit;
1295: end if;
1296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1297: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);
1298: END IF;
1299: END LOOP;
1300: CLOSE reservations;
1301: if l_requirement_header_id is not null then