APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_K_LINES_B

Line 566: OKC_K_LINES_B OKS_COV_PD_CLEB,

562: CURSOR link_csr (p_kle_id OKC_K_LINES_V.ID%TYPE) IS
563: SELECT KREL.chr_id okl_contract_id
564: FROM OKC_K_HEADERS_B OKS_CHRB,
565: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
566: OKC_K_LINES_B OKS_COV_PD_CLEB,
567: OKC_K_REL_OBJS KREL,
568: OKC_LINE_STYLES_B LNK_SRV_LSE,
569: OKC_STATUSES_B LNK_SRV_STS,
570: OKC_K_LINES_B LNK_SRV_CLEB,

Line 570: OKC_K_LINES_B LNK_SRV_CLEB,

566: OKC_K_LINES_B OKS_COV_PD_CLEB,
567: OKC_K_REL_OBJS KREL,
568: OKC_LINE_STYLES_B LNK_SRV_LSE,
569: OKC_STATUSES_B LNK_SRV_STS,
570: OKC_K_LINES_B LNK_SRV_CLEB,
571: OKC_K_ITEMS LNK_SRV_CIM
572: WHERE OKS_CHRB.scs_code = 'SERVICE'
573: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
574: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id

Line 712: FROM OKC_K_LINES_B CLE,

708: -- rmunjulu INVESTOR_DISB_ADJ
709: -- get assets with same status as contract
710: CURSOR get_contract_assets_no_csr (p_khr_id IN NUMBER) IS
711: SELECT COUNT(CLE.id) no_of_contract_assets
712: FROM OKC_K_LINES_B CLE,
713: OKC_LINE_STYLES_B LSE,
714: --OKC_STATUSES_B STS,
715: OKC_K_HEADERS_B CHR
716: WHERE CLE.lse_id = LSE.id

Line 843: FROM OKC_K_LINES_B CLE,

839:
840: -- get any additional assets on contract which are non terminated and not in quote
841: CURSOR get_additional_assets_csr (p_khr_id IN NUMBER, p_qte_id IN NUMBER) IS
842: SELECT 1
843: FROM OKC_K_LINES_B CLE,
844: OKC_LINE_STYLES_B LSE,
845: OKC_K_HEADERS_B CHR
846: WHERE CLE.lse_id = LSE.id
847: AND LSE.lty_code = 'FREE_FORM1'

Line 1840: OKC_K_LINES_B cle

1836: -- Cursor to get the service requests of contract
1837: CURSOR k_service_request_csr IS
1838: SELECT 'x'
1839: FROM OKX_INCIDENT_STATUSES_V xis,
1840: OKC_K_LINES_B cle
1841: WHERE cle.id = xis.contract_service_id
1842: AND cle.dnz_chr_id = p_contract_id
1843: AND xis.status_code IN ('OPEN');
1844:

Line 3517: OKC_K_LINES_B CLE1,

3513: -- to_number(sgn.VALUE) accrual_stream_type_id, --RMUNJULU *** --rmunjulu bug 4399352
3514: cle1.id subsidy_line_id, -- smoduga ***
3515: nvl(kle1.subsidy_override_amount,nvl(kle1.amount,0)) subsidy_amount -- RMUNJULU 3280473
3516: from OKL_K_LINES KLE1,
3517: OKC_K_LINES_B CLE1,
3518: OKC_LINE_STYLES_B LS1,
3519: okl_subsidies_b SUB,
3520: okl_subsidies_tl subt,
3521: OKC_STATUSES_V STS1

Line 4845: ,okc_k_lines_b kle

4841: SELECT stm.sty_id,
4842: SUM(ste.amount) amount
4843: FROM okl_streams stm
4844: ,okl_strm_type_b sty
4845: ,okc_k_lines_b kle
4846: ,okc_statuses_b kls
4847: ,okl_strm_elements ste
4848: WHERE stm.khr_id = p_khr_id
4849: AND stm.active_yn = 'Y'

Line 4866: FROM OKC_k_LINES_B CLE,

4862:
4863: -- rmunjulu TNA Get the FEE and SERVICE Top Lines
4864: CURSOR p_chr_lines_csr(p_chr_id IN NUMBER) IS
4865: SELECT CLE.ID
4866: FROM OKC_k_LINES_B CLE,
4867: OKC_LINE_STYLES_B LTY
4868: WHERE CLE.LSE_ID = LTY.ID
4869: AND LTY.LTY_CODE IN ('FEE', 'SOLD_SERVICE') -- rmunjulu TNA Give the proper Alias
4870: AND CLE.CHR_ID = p_chr_id; -- rmunjulu TNA Give the proper Alias