DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_STATUSES_B

Line 569: OKC_STATUSES_B LNK_SRV_STS,

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,
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

Line 714: --OKC_STATUSES_B STS,

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
717: AND LSE.lty_code = 'FREE_FORM1'
718: --AND CLE.sts_code = STS.code

Line 4846: ,okc_statuses_b kls

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'
4850: AND stm.say_code = 'CURR'