813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,
815: (select SUM(NVL(txd.amount,0))
816: from OKL_TXD_AR_LN_DTLS_B txd,
817: okl_strm_type_b sty
818: where txd.khr_id = khr.id
819: and txd.sty_id = sty.id
820: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
821:
1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,
1848: (select SUM(NVL(txd.amount,0))
1849: from OKL_TXD_AR_LN_DTLS_B txd,
1850: okl_strm_type_b sty
1851: where txd.khr_id = khr.id
1852: and txd.sty_id = sty.id
1853: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1854: