184: AND RLE_CODE=p_cplv_rec.RLE_CODE ;
185:
186: CURSOR get_buy_sell_info IS
187: SELECT BUY_OR_SELL,scs_code FROM
188: okc_k_headers_all_b
189: WHERE id= p_cplv_rec.dnz_chr_id ;
190:
191:
192:
1358: WHERE id= p_ctcv_rec.cpl_id ;
1359:
1360: CURSOR get_header_info IS
1361: SELECT buy_or_sell FROM
1362: okc_k_headers_all_b WHERE
1363: id= p_ctcv_rec.dnz_chr_id;
1364:
1365: CURSOR get_jtot_object_code(p_rle_code IN VARCHAR2,p_BUY_OR_SELL IN varchar2) is
1366: select jtot_object_code ,CONSTRAINED_YN