APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on OKL_K_HEADERS

Line 466: OKL_K_HEADERS KHR

462: CHR.sts_code,
463: CHR.scs_code,
464: CHR.date_terminated
465: FROM OKC_K_HEADERS_B CHR,
466: OKL_K_HEADERS KHR
467: WHERE CHR.id = p_khr_id
468: AND CHR.id = KHR.id;
469:
470: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 826: FROM OKL_K_HEADERS_V

822:
823: -- Cursor to get the product of the contract
824: CURSOR prod_id_csr (p_khr_id IN NUMBER) IS
825: SELECT pdt_id
826: FROM OKL_K_HEADERS_V
827: WHERE id = p_khr_id;
828:
829: -- Cursor to get the code_combination_id for the transaction id and
830: -- transaction table

Line 1915: OKL_K_HEADERS KHR

1911: CURSOR get_expired_khr_csr (p_date IN DATE) IS
1912: SELECT CHR.id,
1913: CHR.contract_number contract_number
1914: FROM OKC_K_HEADERS_B CHR,
1915: OKL_K_HEADERS KHR
1916: WHERE KHR.ID = CHR.ID
1917: AND CHR.sts_code IN ('TERMINATED','EXPIRED') -- TERMINATED/EXPIRED
1918: AND trunc(CHR.date_terminated) <= TRUNC(p_date) -- Ended
1919: AND CHR.id NOT IN (-- balance writeoffs already done when contract was fully terminated