7155: AND pod.oke_contract_line_id NOT IN (SELECT id
7156: FROM okc_k_lines_b
7157: WHERE dnz_chr_id = pol.oke_contract_header_id
7158: --
7159: -- Look for contract lines in oke_deliverables_b also (DTS flow)
7160: UNION
7161: SELECT deliverable_id
7162: FROM oke_deliverables_b
7163: WHERE source_header_id = pol.oke_contract_header_id);
7158: --
7159: -- Look for contract lines in oke_deliverables_b also (DTS flow)
7160: UNION
7161: SELECT deliverable_id
7162: FROM oke_deliverables_b
7163: WHERE source_header_id = pol.oke_contract_header_id);
7164:
7165: --Increment the p_sequence with number of errors reported in last query
7166: p_sequence := p_sequence + SQL%ROWCOUNT;