APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 816: from OKL_TXD_AR_LN_DTLS_B txd,

812: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
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,

Line 1009: from OKL_TXD_AR_LN_DTLS_B txd

1005:
1006: null CONTRACT_TOT_PAST_DUE_AMT,
1007: -- null CONTRACT_TOT_BILLED_RECEIVABLE,
1008: (select SUM(NVL(txd.amount,0))
1009: from OKL_TXD_AR_LN_DTLS_B txd
1010: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
1011:
1012: /*
1013: -- for Net Investment

Line 1849: from OKL_TXD_AR_LN_DTLS_B txd,

1845: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_total_debits(chr.id, null),0) TOTAL_DEBITS_FOR_PREFUNDING,
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,

Line 2041: from OKL_TXD_AR_LN_DTLS_B txd

2037:
2038: null CONTRACT_TOT_PAST_DUE_AMT,
2039: -- null CONTRACT_TOT_BILLED_RECEIVABLE,
2040: (select SUM(NVL(txd.amount,0))
2041: from OKL_TXD_AR_LN_DTLS_B txd
2042: where txd.khr_id = khr.id ) CONTRACT_TOT_BILLED_RECEIVABLE,
2043:
2044: /*
2045: -- for Net Investment