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