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 5143: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

5139: WHERE KHR_ID = p_contract_id
5140: AND ID = p_quote_id;
5141: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
5142: SELECT OST.STE_CODE
5143: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
5144: WHERE KHR.ID = p_khr_id
5145: AND KHR.STS_CODE = OST.CODE ;
5146: -- Get start date and end date for rebook contract ---
5147: CURSOR okc_new_k_effdate_csr(p_khr_id IN NUMBER) IS