eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_K_LINES_B

Line 458: from okc_k_lines_b cle,

454: --cursor to check if there is a lse_id line for k
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

Line 466: l_kle_id OKC_K_LINES_B.ID%TYPE;

462: and cle.sts_code = sts.code
463: and sts.code not in ('ACTIVE','HOLD','EXPIRED','TERMINATED','CANCELED')
464: and nvl(cle.end_date,sysdate+1) > sysdate;
465:
466: l_kle_id OKC_K_LINES_B.ID%TYPE;
467:
468: --cursor to ceck if rule group is already attached at the k line level
469: CURSOR chk_rgp_csr (p_khr_id IN NUMBER,
470: p_kle_id IN NUMBER,