APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on OKC_K_HEADERS_B

Line 465: FROM OKC_K_HEADERS_B CHR,

461: CHR.end_date,
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:

Line 1914: FROM OKC_K_HEADERS_B CHR,

1910: -- Get the terminated/expired contracts for the org
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