APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 509: FROM okc_k_headers_b chrb,

505: --cursor to check if the contract is selected for Mass Rebook
506: CURSOR l_chk_mass_rbk_csr
507: IS
508: SELECT '1'
509: FROM okc_k_headers_b chrb,
510: okl_trx_contracts ktrx
511: WHERE chrb.ID = p_chr_id
512: AND ktrx.khr_id = chrb.id
513: AND ktrx.tsu_code = 'ENTERED'

Line 551: FROM okc_k_headers_b chrb,

547: --cursor to check if the contract is rebooked contract
548: CURSOR l_chk_rbk_csr
549: IS
550: SELECT '1'
551: FROM okc_k_headers_b chrb,
552: okl_trx_contracts ktrx
553: WHERE ktrx.khr_id_new = chrb.id
554: AND ktrx.tsu_code = 'ENTERED'
555: AND ktrx.rbr_code IS NOT NULL

Line 589: FROM okc_k_headers_b chrb

585: --cursor to check if contract is a re-lease contract
586: CURSOR l_chk_rel_khr_csr
587: IS
588: SELECT '1'
589: FROM okc_k_headers_b chrb
590: WHERE chrb.id = p_chr_id
591: AND NVL(chrb.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
592:
593: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;

Line 618: FROM okc_k_headers_b chrb

614:
615: --cursor to check if contract has re-lease assets
616: CURSOR l_chk_rel_ast_csr IS
617: SELECT '1'
618: FROM okc_k_headers_b chrb
619: WHERE NVL(chrb.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
620: AND chrb.ID = p_chr_id
621: AND EXISTS (SELECT '1'
622: FROM okc_rules_b rul

Line 747: p_chr_id okc_k_headers_b.id%TYPE)

743: RETURN(NULL);
744: END get_contract_process;
745:
746: FUNCTION is_lease_contract(
747: p_chr_id okc_k_headers_b.id%TYPE)
748: RETURN VARCHAR2
749: IS
750: CURSOR l_okl_chr_scs_csr
751: IS

Line 753: FROM okc_k_headers_b

749: IS
750: CURSOR l_okl_chr_scs_csr
751: IS
752: SELECT scs_code
753: FROM okc_k_headers_b
754: WHERE id = p_chr_id;
755:
756: l_scs_code okc_k_headers_b.scs_code%TYPE := NULL;
757: l_return_value VARCHAR2(1):= OKL_API.G_FALSE;

Line 756: l_scs_code okc_k_headers_b.scs_code%TYPE := NULL;

752: SELECT scs_code
753: FROM okc_k_headers_b
754: WHERE id = p_chr_id;
755:
756: l_scs_code okc_k_headers_b.scs_code%TYPE := NULL;
757: l_return_value VARCHAR2(1):= OKL_API.G_FALSE;
758: BEGIN
759: FOR l_okl_chr_scs_rec IN l_okl_chr_scs_csr
760: LOOP

Line 1579: FROM okc_k_headers_b chrb,

1575: --cursor to fetch last activation date
1576: CURSOR l_last_activation_date_csr(p_chr_id IN NUMBER)
1577: IS
1578: SELECT MAX(ktrx.transaction_date)
1579: FROM okc_k_headers_b chrb,
1580: okl_trx_contracts ktrx
1581: WHERE chrb.id = p_chr_id
1582: AND ktrx.khr_id = chrb.id
1583: AND ktrx.tsu_code = 'PROCESSED'