APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT dependencies on OKC_K_HEADERS_B

Line 271: FROM OKC_K_HEADERS_B chr,

267: -- commenting where condition for Evergreen contracts processing
268: CURSOR select_contracts_csr IS
269: SELECT chr.id,
270: chr.contract_number
271: FROM OKC_K_HEADERS_B chr,
272: OKL_K_HEADERS khr
273: WHERE chr.scs_code = 'LEASE'
274: AND chr.id = khr.id
275: AND chr.sts_code IN ('BOOKED','EVERGREEN') --bug 3448057. Removing approved and under revision status

Line 362: FROM OKC_K_HEADERS_B

358:
359: -- cursor to select agreement number
360: CURSOR agr_num_csr(p_agr_id NUMBER) IS
361: SELECT contract_number
362: FROM OKC_K_HEADERS_B
363: WHERE id = p_agr_id;
364:
365: TYPE depr_contracts_rec_type IS RECORD
366: (contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,