APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_STRM_ELEMENTS

Line 340: OKL_STRM_ELEMENTS STE,

336: p_rbkadj_sty_id IN NUMBER) IS
337: SELECT
338: sum(ste.amount)
339: FROM
340: OKL_STRM_ELEMENTS STE,
341: OKL_STREAMS STM,
342: OKL_STRM_TYPE_V STY
343: WHERE ste.amount <> 0
344: AND stm.id = ste.stm_id

Line 365: OKL_STRM_ELEMENTS STE,

361: p_rbkadj_sty_id IN NUMBER) IS
362: SELECT
363: sum(ste.amount)
364: FROM
365: OKL_STRM_ELEMENTS STE,
366: OKL_STREAMS STM,
367: OKL_STRM_TYPE_V STY,
368: OKL_STRM_ELEMENTS BILLED_STE
369: WHERE ste.amount <> 0

Line 368: OKL_STRM_ELEMENTS BILLED_STE

364: FROM
365: OKL_STRM_ELEMENTS STE,
366: OKL_STREAMS STM,
367: OKL_STRM_TYPE_V STY,
368: OKL_STRM_ELEMENTS BILLED_STE
369: WHERE ste.amount <> 0
370: AND stm.id = ste.stm_id
371: AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only
372: AND ste.date_billed IS NULL -- NOT YET disbursed (fake or real)

Line 665: OKL_STRM_ELEMENTS STE,

661: p_rbkadj_sty_id IN NUMBER) IS
662: SELECT
663: sum(ste.amount)
664: FROM
665: OKL_STRM_ELEMENTS STE,
666: OKL_STREAMS STM,
667: OKL_STRM_TYPE_V STY
668: WHERE ste.amount <> 0
669: AND stm.id = ste.stm_id

Line 691: OKL_STRM_ELEMENTS STE,

687: p_rbkadj_sty_id IN NUMBER) IS
688: SELECT
689: sum(ste.amount)
690: FROM
691: OKL_STRM_ELEMENTS STE,
692: OKL_STREAMS STM,
693: OKL_STRM_TYPE_V STY,
694: OKL_STRM_ELEMENTS BILLED_STE
695: WHERE ste.amount <> 0

Line 694: OKL_STRM_ELEMENTS BILLED_STE

690: FROM
691: OKL_STRM_ELEMENTS STE,
692: OKL_STREAMS STM,
693: OKL_STRM_TYPE_V STY,
694: OKL_STRM_ELEMENTS BILLED_STE
695: WHERE ste.amount <> 0
696: AND stm.id = ste.stm_id
697: AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only
698: AND ste.date_billed IS NULL -- NOT YET disbursed (fake or real)