194: --- Fetch quote satus
195:
196: CURSOR k_quotes_csr (p_qte_id IN NUMBER) IS
197: SELECT qst_code
198: FROM okl_trx_quotes_v
199: WHERE id = p_qte_id
200: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
201:
202: BEGIN
344: )
345: IS
346: SELECT qte.qtp_code qtp_code,
347: qte.qrs_code qrs_code
348: FROM okl_trx_quotes_v qte
349: WHERE qte.ID = p_quote_id;
350:
351: -- Cursor to get the k details
352: -- RMUNJULU 06-MAR-03 Performance Fix Replaced K_HDR_FULL