APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 508: FROM okc_k_headers_b chrb,

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

Line 550: FROM okc_k_headers_b chrb,

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

Line 588: FROM okc_k_headers_b chrb

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

Line 617: FROM okc_k_headers_b chrb

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

Line 746: p_chr_id okc_k_headers_b.id%TYPE)

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

Line 752: FROM okc_k_headers_b

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

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

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