58: sll.rule_information13 rate,
59: rgp.cle_id cle_id
60: from okc_rules_b sll,
61: okc_rules_b slh,
62: okl_strm_type_v styp,
63: okc_rule_groups_b rgp
64: where to_number(sll.object2_id1) = slh.id
65: and sll.rule_information_category = 'LASLL'
66: and sll.dnz_chr_id = rgp.dnz_chr_id
300: sll.rule_information7 stub_days,
301: sll.rule_information8 stub_amount
302: from okc_rules_b sll,
303: okc_rules_b slh,
304: okl_strm_type_v styp,
305: okc_rule_groups_b rgp
306: where to_number(sll.object2_id1) = slh.id
307: and sll.rule_information_category = 'LASLL'
308: and sll.dnz_chr_id = rgp.dnz_chr_id