Line 195: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
191: AND crg.dnz_chr_id = chrId
192: AND crg.cle_id = cleId
193: -- ORDER BY crl.rule_information1;
194: --start bug#2757289 bakuchib 195: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2); 196: --end bug#2757289 bakuchib
197: -- get the Line rule information
198: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,
199: rlcat okc_rules_b.rule_information_category%TYPE,