245: --Added by kthiruva for Bug 6691554
246: CURSOR get_ia_sts_csr(p_khr_id NUMBER)
247: IS
248: SELECT khr.STS_CODE
249: FROM okc_k_headers_all_b khr
250: WHERE khr.ID = p_khr_id
251: AND khr.SCS_CODE = 'INVESTOR';
252:
253: /*
347: -------------------------------------------------------------------------
348:
349: l_legal_entity_id RA_INTERFACE_LINES.LEGAL_ENTITY_ID%TYPE; -- for LE Uptake project 08-11-2006
350: --Added by kthiruva for bug 6691554
351: l_status_code OKC_K_HEADERS_ALL_B.STS_CODE%TYPE;
352:
353: BEGIN
354: ------------------------------------------------------------
355: -- Start processing