618: FROM okc_k_headers_b chrb
619: WHERE NVL(chrb.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
620: AND chrb.ID = p_chr_id
621: AND EXISTS (SELECT '1' 622: FROM okc_rules_b rul 623: WHERE rul.dnz_chr_id = chrb.id
624: AND rul.rule_information_category = 'LARLES'
625: AND NVL(rule_information1,'N') = 'Y');
626: