1128: rel.rty_code = 'OKLSRV';
1129:
1130: CURSOR get_k_info_csr(p_chr_id number) IS
1131: SELECT currency_code,sts_code
1132: from okc_k_headers_v chr
1133: where chr.id = p_chr_id;
1134:
1135: CURSOR get_lse_id_csr(p_chr_id number, p_cle_id number) IS
1136: select lse.id,lse.lty_code
1610: rel.rty_code = 'OKLSRV';
1611:
1612: CURSOR get_k_info_csr(p_chr_id number) IS
1613: SELECT currency_code,sts_code
1614: from okc_k_headers_v chr
1615: where chr.id = p_chr_id;
1616:
1617: CURSOR get_lse_id_csr(p_chr_id number, p_cle_id number) IS
1618: select lse.id,lse.lty_code