APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKC_STATUSES_B

Line 518: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

514: ) RETURN VARCHAR2 IS
515: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
516: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
517: SELECT STE_CODE
518: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
519: WHERE KHR.ID = p_khr_id
520: AND KHR.STS_CODE = OST.CODE;
521:
522: BEGIN

Line 908: ,OKC_STATUSES_B OKSB

904: ,OKHB.ORG_ID
905: --Bug # 6318957 SSDESHPA Changes End
906: FROM OKC_K_HEADERS_B OKHB
907: ,OKL_K_HEADERS OKLH
908: ,OKC_STATUSES_B OKSB
909: WHERE OKSB.STE_CODE = 'ACTIVE' AND
910: OKHB.STS_CODE = OKSB.CODE AND
911: OKHB.SCS_CODE = 'LEASE' AND
912: OKHB.END_DATE > SYSDATE AND