APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_STATUSES_B

Line 409: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

405: ) RETURN VARCHAR2 IS
406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
407: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
408: SELECT STE_CODE
409: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
410: WHERE KHR.ID = p_khr_id
411: AND KHR.STS_CODE = OST.CODE ;
412:
413: BEGIN

Line 5150: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

5146: WHERE KHR_ID = p_contract_id
5147: AND ID = p_quote_id;
5148: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
5149: SELECT OST.STE_CODE
5150: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
5151: WHERE KHR.ID = p_khr_id
5152: AND KHR.STS_CODE = OST.CODE ;
5153: -- Get start date and end date for rebook contract ---
5154: CURSOR okc_new_k_effdate_csr(p_khr_id IN NUMBER) IS