DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_STATUSES_B

Line 547: OKC_STATUSES_B LNK_SRV_STS,

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

Line 692: --OKC_STATUSES_B STS,

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

Line 4824: ,okc_statuses_b kls

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