29: AND v.in_process_yn='Y';
30:
31: CURSOR cur_status(p_sts_code varchar2) is
32: SELECT ste_code
33: FROM okc_statuses_b
34: WHERE code = p_sts_code;
35:
36: CURSOR cur_mean(p_sts_code varchar2) is
37: SELECT meaning
193: WHERE id = p_chr_id;
194:
195: CURSOR c_sts(p_code IN VARCHAR2) IS
196: SELECT ste_code
197: FROM okc_statuses_b
198: WHERE code = p_code;
199:
200: BEGIN
201: