APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_K_LINES_B

Line 544: OKC_K_LINES_B OKS_COV_PD_CLEB,

540: CURSOR link_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
541: SELECT KREL.chr_id okl_contract_id
542: FROM OKC_K_HEADERS_B OKS_CHRB,
543: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
544: OKC_K_LINES_B OKS_COV_PD_CLEB,
545: OKC_K_REL_OBJS KREL,
546: OKC_LINE_STYLES_B LNK_SRV_LSE,
547: OKC_STATUSES_B LNK_SRV_STS,
548: OKC_K_LINES_B LNK_SRV_CLEB,

Line 548: OKC_K_LINES_B LNK_SRV_CLEB,

544: OKC_K_LINES_B OKS_COV_PD_CLEB,
545: OKC_K_REL_OBJS KREL,
546: OKC_LINE_STYLES_B LNK_SRV_LSE,
547: OKC_STATUSES_B LNK_SRV_STS,
548: OKC_K_LINES_B LNK_SRV_CLEB,
549: OKC_K_ITEMS LNK_SRV_CIM
550: WHERE OKS_CHRB.scs_code = 'SERVICE'
551: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
552: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id

Line 690: FROM OKC_K_LINES_B CLE,

686: -- rmunjulu INVESTOR_DISB_ADJ
687: -- get assets with same status as contract
688: CURSOR get_contract_assets_no_csr (p_khr_id IN NUMBER) IS
689: SELECT COUNT(CLE.id) no_of_contract_assets
690: FROM OKC_K_LINES_B CLE,
691: OKC_LINE_STYLES_B LSE,
692: --OKC_STATUSES_B STS,
693: OKC_K_HEADERS_B CHR
694: WHERE CLE.lse_id = LSE.id

Line 821: FROM OKC_K_LINES_B CLE,

817:
818: -- get any additional assets on contract which are non terminated and not in quote
819: CURSOR get_additional_assets_csr (p_khr_id IN NUMBER, p_qte_id IN NUMBER) IS
820: SELECT 1
821: FROM OKC_K_LINES_B CLE,
822: OKC_LINE_STYLES_B LSE,
823: OKC_K_HEADERS_B CHR
824: WHERE CLE.lse_id = LSE.id
825: AND LSE.lty_code = 'FREE_FORM1'

Line 1818: OKC_K_LINES_B cle

1814: -- Cursor to get the service requests of contract
1815: CURSOR k_service_request_csr IS
1816: SELECT 'x'
1817: FROM OKX_INCIDENT_STATUSES_V xis,
1818: OKC_K_LINES_B cle
1819: WHERE cle.id = xis.contract_service_id
1820: AND cle.dnz_chr_id = p_contract_id
1821: AND xis.status_code IN ('OPEN');
1822:

Line 3495: OKC_K_LINES_B CLE1,

3491: -- to_number(sgn.VALUE) accrual_stream_type_id, --RMUNJULU *** --rmunjulu bug 4399352
3492: cle1.id subsidy_line_id, -- smoduga ***
3493: nvl(kle1.subsidy_override_amount,nvl(kle1.amount,0)) subsidy_amount -- RMUNJULU 3280473
3494: from OKL_K_LINES KLE1,
3495: OKC_K_LINES_B CLE1,
3496: OKC_LINE_STYLES_B LS1,
3497: okl_subsidies_b SUB,
3498: okl_subsidies_tl subt,
3499: OKC_STATUSES_V STS1

Line 4823: ,okc_k_lines_b kle

4819: SELECT stm.sty_id,
4820: SUM(ste.amount) amount
4821: FROM okl_streams stm
4822: ,okl_strm_type_b sty
4823: ,okc_k_lines_b kle
4824: ,okc_statuses_b kls
4825: ,okl_strm_elements ste
4826: WHERE stm.khr_id = p_khr_id
4827: AND stm.active_yn = 'Y'

Line 4844: FROM OKC_k_LINES_B CLE,

4840:
4841: -- rmunjulu TNA Get the FEE and SERVICE Top Lines
4842: CURSOR p_chr_lines_csr(p_chr_id IN NUMBER) IS
4843: SELECT CLE.ID
4844: FROM OKC_k_LINES_B CLE,
4845: OKC_LINE_STYLES_B LTY
4846: WHERE CLE.LSE_ID = LTY.ID
4847: AND LTY.LTY_CODE IN ('FEE', 'SOLD_SERVICE') -- rmunjulu TNA Give the proper Alias
4848: AND CLE.CHR_ID = p_chr_id; -- rmunjulu TNA Give the proper Alias