APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_STATUSES_B

Line 459: okc_statuses_b sts

455: CURSOR chk_lse_csr (p_khr_id IN NUMBER,
456: p_lse_id IN NUMBER) IS
457: select cle.id
458: from okc_k_lines_b cle,
459: okc_statuses_b sts
460: where cle.dnz_chr_id = p_khr_id
461: and cle.lse_id = p_lse_id
462: and cle.sts_code = sts.code
463: and sts.code not in ('ACTIVE','HOLD','EXPIRED','TERMINATED','CANCELED')