255: rle.template_yn,
256: rle.comments,
257: rlg.rgd_code
258: FROM okc_rules_b rle,
259: okc_k_party_roles_b prl,
260: okc_k_party_roles_b prl1,
261: okc_rule_groups_b rlg
262: WHERE rle.dnz_chr_id = cp_chr_id
263: AND prl.dnz_chr_id = cp_chr_id
256: rle.comments,
257: rlg.rgd_code
258: FROM okc_rules_b rle,
259: okc_k_party_roles_b prl,
260: okc_k_party_roles_b prl1,
261: okc_rule_groups_b rlg
262: WHERE rle.dnz_chr_id = cp_chr_id
263: AND prl.dnz_chr_id = cp_chr_id
264: AND prl.rle_code = prl1.rle_code