DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_STRM_TYPE_B

Line 803: okl_strm_type_b sty

799: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
800: -- null CONTRACT_BILLED_RENTS,
801: (select SUM(NVL(txd.amount,0))
802: from OKL_TXD_AR_LN_DTLS_B txd,
803: okl_strm_type_b sty
804: where txd.khr_id = khr.id
805: and txd.sty_id = sty.id
806: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
807:

Line 1836: okl_strm_type_b sty

1832: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1833: -- null CONTRACT_BILLED_RENTS,
1834: (select SUM(NVL(txd.amount,0))
1835: from OKL_TXD_AR_LN_DTLS_B txd,
1836: okl_strm_type_b sty
1837: where txd.khr_id = khr.id
1838: and txd.sty_id = sty.id
1839: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1840: