2577: and chr_id is not null;
2578: cursor c3 is
2579: select a.lse_id
2580: from okc_k_lines_b a, 2581: okc_ancestrys b 2582: where b.cle_id = p_line_id
2583: and b.level_sequence = 1
2584: and a.id = b.cle_id_ascendant;
2585: cursor c4(p_lse_id okc_val_line_operations_v.lse_id%TYPE) is